View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerid B Jerid B is offline
external usenet poster
 
Posts: 20
Default 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!