I'm trying to build a spreadsheet and I'm running into the issue that I need the decimal rounded to the nearest quarter (0.00, 0.25, 0.50, 0.75). I've looked into custom formats but that only allows three rules and to get what I need, I'd need a minimum of 5 rules.
I'm working with basic division across 12 total cells. The numbers that will be used with it change daily.
Does anyone know a way to do this or work around to it?
Mac mini, macOS 12.4
The easiest way is to use MROUND MROUND - Apple Support
MROUND($A2,0.25) will always round to the next quarter
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
The easiest way is to use MROUND MROUND - Apple Support
MROUND($A2,0.25) will always round to the next quarter
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
Hi Ralf,
Slip of the fingers?
"MROUND($A2,0.25) will always round to the next quarter."
In your example, the values in rows 3, 5, 8 and 10 are rounded down to the previous quarter.
"MROUND($A2,0.25) will round to the nearest quarter" seems more accurate.
Regards,
Barry
Custom Rounding
