Arithmetic operators in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales assistant at a small retail store.

📋 Request: Your manager wants you to calculate the total price, tax amount, and final price for each product sold.

📊 Data: You have a list of products with their unit price and quantity sold. The sales tax rate is 8%.

🎯 Deliverable: Create a spreadsheet that calculates the total price before tax, the tax amount, and the final price including tax for each product.

Sample Data

Product	Unit Price	Quantity Sold
Notebook	2.50	10
Pen	1.20	15
Eraser	0.50	20
Marker	3.00	5
Folder	1.75	8

1

Step 1: Calculate the total price before tax for each product by multiplying Unit Price by Quantity Sold.

=B2*C2

Expected Result

Notebook total price: 25.00

2

Step 2: Calculate the tax amount for each product by multiplying the total price by the tax rate (8%).

=D2*0.08

Expected Result

Notebook tax amount: 2.00

3

Step 3: Calculate the final price including tax by adding the total price and the tax amount.

=D2+E2

Expected Result

Notebook final price: 27.00

4

Step 4: Copy the formulas down for all products to calculate total price, tax amount, and final price for each.

Drag formulas in columns D, E, and F down from row 2 to row 6.

Expected Result

All products have total price, tax amount, and final price calculated.

Final Result

Product   Unit Price  Quantity Sold  Total Price  Tax Amount  Final Price
Notebook  2.50        10             25.00        2.00        27.00
Pen       1.20        15             18.00        1.44        19.44
Eraser    0.50        20             10.00        0.80        10.80
Marker    3.00        5              15.00        1.20        16.20
Folder    1.75        8              14.00        1.12        15.12

✓The total price is calculated by multiplying unit price and quantity sold.

✓The tax amount is 8% of the total price.

✓The final price is the sum of total price and tax amount.

✓This helps the manager see the exact amount earned including tax for each product.

Bonus Challenge

Add a new column that calculates the discount price if a 10% discount is applied before tax.

Show Hint

Calculate discount price as Total Price * 0.90, then calculate tax on the discounted price.