Rounding numbers

  • Thread starter Thread starter Debbie
  • Start date Start date
D

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?
 
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
 
Back
Top