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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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) .
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help in round up or down price to specific ending number 2
How to determine the closest degree? 2
How to determine the closed value? 7
How to determine the closest value? 7
How to determine the closest value? 2
rounding currency amounts 4
how to multiply two values and round the result 5
Round Number to Nearest 50 3

Back
Top