Chapter 7 Case study: monthly sales report ・ MISSION 30

Mission 30: Amounts from a price list

📋 Mission list

Task

In C2:C6, show the amount as the unit price from the price list (columns E–F) × quantity.

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 30

Amounts from a price list

In C2:C6, show the amount as the unit price from the price list (columns E–F) × quantity.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =VLOOKUP(A2,$E$2:$F$4,2,FALSE)*B2

A function's result can be used in a calculation right away. Like VLOOKUP(…)*B2, you can multiply the looked-up value by the quantity in one formula.

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