Rounding numbers

[Debbie]

I have a column of dollar figures. I need them to round up
or down to the nearest .05. Example: 5.21 and 5.22 would
round down to 5.20 and 5.23 and 5.24 would round up to
5.25. Is there a way to do this?

 

[Peo Sjoblom]

One way

=ROUND(A1/0.05,0)*0.05

where A1 hold the amount

 

[Frank Kabel]

Hi Debbie,

try the following formula (if your value is stored in A):
=ROUND(A1*2,1)/2

or if you have the Analysis Tool Add-in installed you can also use
=MROUND(A1,0.05)

Frank