Administration and Executive AssistantTier 815 minbeginner

MROUND vs ROUND

Band a cash figure to the nearest R5, not the nearest whole rand.

What you will learn

• Use MROUND to round a value to the nearest multiple of an arbitrary number
• Explain the difference between MROUND and ROUND
• Recognise when ROUND silently does nothing because the value is already whole

Excel skills

MROUND · Rounding

The task

Eight tills need their reconciled cash amount banded to the nearest R5. Work out the first till'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