S
sueshe
I have a list of numbers I am trying to round to the closest .50, can anyone
help me? ex. 264.68 would be 264.50; 264.97 would be 265.00
help me? ex. 264.68 would be 264.50; 264.97 would be 265.00
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Naz
You can used the MROUND function (ensure the Analysis tool pack add-in is
intalled).
i.e.
=MROUND(A1,0.5)
where A1 contains the amount to be rounded.
Hope that helps
___________________
Naz
London
intalled).
i.e.
=MROUND(A1,0.5)
where A1 contains the amount to be rounded.
Hope that helps
___________________
Naz
London
S
Sandy Mann
Or without the Analysis tool pack add-in try:
=ROUND(A1*2,0)/2
HTH
Sandy
=ROUND(A1*2,0)/2
HTH
Sandy
S
sueshe
Thanks to both of you, I had tried the =ROUND(a1,0.5) but it just gave me an
error, so I'll try either of the methods you mentioned, thanks again!!!
error, so I'll try either of the methods you mentioned, thanks again!!!
R
RCW
=CEILING(FLOOR(A1,0.25),0.5)
where A1 is the number to be incremented to $.50. The possible advantage of
this solution is that you wouldn't have to be incrementing up or down from
the exact midpoint (-i.e. down from .24 and up from .25) .
where A1 is the number to be incremented to $.50. The possible advantage of
this solution is that you wouldn't have to be incrementing up or down from
the exact midpoint (-i.e. down from .24 and up from .25) .