I am trying to round currency to the closest .50, can anyone tell.
 

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

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

"sueshe" wrote:

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

Or without the Analysis tool pack add-in try:

=ROUND(A1*2,0)/2

HTH

Sandy
--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"sueshe" wrote in message
...
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

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!!!

"sueshe" wrote:

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

=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) .

"Sandy Mann" wrote:

Or without the Analysis tool pack add-in try:

=ROUND(A1*2,0)/2

HTH

Sandy
--
to e-mail direct replace @mailintor.com with @tiscali.co.uk


"sueshe" wrote in message
...
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