Chapter 7 Case study: monthly sales report ・ MISSION 29

Mission 29: Did they reach the target?

📋 Mission list

Task

In G2:G4, show “Met” if the total sales are at least the target in F6, and “Missed” if not.

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 7 ・ MISSION 29

Did they reach the target?

In G2:G4, show “Met” if the total sales are at least the target in F6, and “Missed” if not.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =IF(F2>=$F$6,"Met","Missed")

Point to the target cell instead of typing 200000 into the formula. When the target changes, you only need to change F6.

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).