SheetsdrillRound the unit price
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Work out the price per unit (invoice total divided by units) and round it to 2 decimal places. Answer in B3.
What this exercise teaches
Number formatting only changes how a value looks. ROUND changes the value itself, which matters when it feeds other formulas.
A hint if you get stuck
ROUND(value, places). Put the division inside ROUND as the first argument.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise