FinanceTier 810 minbeginner

Round Petty Cash to the Nearest R5

Band a counted cash amount to the nearest R5, not just to the nearest whole rand.

What you will learn

• Use MROUND to round to the nearest multiple of a chosen value
• Explain why ROUND(amount,0) does nothing to an amount that is already a whole rand
• Recognise when a value needs banding to a multiple, not just a decimal place

Excel skills

MROUND · Rounding

The task

Eight petty cash floats need their counted amount banded to the nearest R5. Work out the first float's banded figure in Summary!B3.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free