Roundup by .05

[Drmwvr7266]

I use to know how to do this. But I can't remember what function I really used. I don't think it was a Roundup or rounddown or round function.

 

[kskinne]

=CEILING(A1,0.05)

where A1 is the cell containing the number you want to round to the nearest .05. this formula rounds you value up to the nearest .05

 

[Drmwvr7266]

Thank you