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
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks