Math & trig › ROUND15 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFreeROUND

ROUND: selling price to the nearest thousand

Mrs. Ratna sells frozen food in Depok. Her selling price is the cost plus a markup, but the result often has odd tails like Rp48,125. She wants prices rounded to the nearest thousand so the price labels look tidy.

Task

Fill D2:D6 with the selling price: the cost (column B) times (1 + the markup in column C), then rounded to the nearest thousand with ROUND.

Cells to fillD2:D6

Required functionsROUND

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
ROUND(number, digits): 0 digits rounds to a whole number, positive digits round to decimals, and negative digits round to tens, hundreds or thousands.
Hint 2
Thousands means 3 places to the left of the decimal point, so the digits argument is -3.
Hint 3
Calculate the price inside ROUND: B2*(1+C2) as the first argument.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

D2:D6

=ROUND(B2*(1+C2),-3)

Write it in D2, then fill down to D6.

Explanation

=ROUND(B2*(1+C2),-3) rounds to the nearest multiple of 1,000: Rp48,125 becomes Rp48,000 and Rp40,500 becomes Rp41,000 (a 5 rounds up). Changing the cell format only hides the tail; the real value stays and totals can be off. If the price must always go up, use ROUNDUP; always down, use ROUNDDOWN; for other multiples such as 500, use MROUND.

Starting worksheet: Sheet1
Row	A	B	C	D
1	Product	Cost	Markup	Selling price
2	Chicken nuggets 500 g	38,500	25%
3	Beef sausages 500 g	41,200	30%
4	Beef meatballs, 50 pcs	35,750	20%
5	Chicken dim sum, 20 pcs	28,900	35%
6	French fries 1 kg	32,400	25%
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result