Rounding to the nearest 50 cents
 

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!

Rounding to the nearest 50 cents
 

One way:


=ROUND(A1*2,0)/2

In article ,
Jerid B wrote:

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!

Rounding to the nearest 50 cents
 

=MROUND(A1,0.5)

tyr this

"Jerid B" wrote:

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!

Rounding to the nearest 50 cents
 

Hi,

Try:

=MROUND(A1,0.5)

HTH
Jean-Guy

"Jerid B" wrote:

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!

Rounding to the nearest 50 cents
 

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

"Jerid B" wrote in message
...
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!