In Mac Numbers, How do I round to the nearest 5 cents
I like to round a currency in 5 cents steps, like 1.20. 1.25. 1.30 how can I do this?
I like to round a currency in 5 cents steps, like 1.20. 1.25. 1.30 how can I do this?
you need the MROUND function, linked by Ralf-F already.
use 0.05 as the numeric second argument. This rounds up and down if it is closer to the lower or higher 0.05 it seems.
if you need to only go up, it would take more work
Here are options that you can use to round values
They all round numbers in different ways, based on what you want.
Mostly you will need the top 3 options.
To round to the closest 5 cent you can use MRound
Regards Ralf
to round up, use CEILING with 0.05 being the number in the second argument
are you rounding UP all the time to the nearest .05?
In Mac Numbers, How do I round to the nearest 5 cents