Chapter 3 Making decisions ・ MISSION 13

Mission 13: What to show after dividing by 0

📋 Mission list

Task

In D2 and D3, find the unit price as sales ÷ quantity. For rows with a quantity of 0, show “-”.

Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.

Chapter 3 ・ MISSION 13

What to show after dividing by 0

In D2 and D3, find the unit price as sales ÷ quantity. For rows with a quantity of 0, show “-”.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =IFERROR(B2/C2,"-")

IFERROR returns the second value only when the formula gives an error; otherwise it returns the result as is. So the same formula also works on normal rows like D2.

To practice one function at a time:Function drillExcel function list

* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).