Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I round up the result of a sum | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
How can i round off .10 as .50 and .51 as 1.00 | Excel Worksheet Functions | |||
Round Time | Excel Worksheet Functions | |||
Closest number match help ... | Excel Worksheet Functions |