Rounding to the nearest 50 cents

[Guest]

Excel 2003 running on Win XP... all SP
We usually round to the nearest dollar mark, but now they want to get more
exact.
So now our Customer Service wants rounding to the nearest 50 cents.
Example:
$15.64 would equal $15.50
$15.88 would equal $16.00

I've looked in roundup functions and can't find a way to do this. Any help
would be greatly appreciated.

Thank you!

 

[JE McGimpsey]

One way:


=ROUND(A1*2,0)/2

 

[Guest]

=MROUND(A1,0.5)

tyr this

 

[Guest]

Hi,

Try:

=MROUND(A1,0.5)

HTH
Jean-Guy

 

[David Biddulph]

=MROUND(A1,0.5) needs Analysis ToolPak
otherwise =ROUND(A1*2,0)/2