Rounding Numbers that are decimals

[Necco]

I hoping this is simple and makes sense so here goes! I am looking for a formula to round a number to the nearest .025. For example Cell A1 contains .0280 and I need to round it the to the nearest .025, in this case .030 as my results have to be in .025 increments.

 

[cerfani]

=ROUND(A1/0.025,0)*0.025

try that, btw, the nearest .025 increment to 0.028 is 0.025, the next increment would be 0.05

 

[Rick Rothstein]

=ROUND(A1/0.025,0)*0.025

try that, btw, the nearest .025 increment to 0.028 is 0.025, the next increment would be 0.05

A shorter formula for this...

=MROUND(A1,0.025)

 

[cerfani]

A shorter formula for this...

=MROUND(A1,0.025)

Oh thanks, didn't know about that one!

 

[Hydestone]

how would this be written to round up to the nearest $0.05?

 

[Fluff]

To roundup you need to use the Ceiling function