Kathleen_klr Wrote:
Mr. Ben,
Thank you for your reply. However, I used this number $633.33, when I
use
your formula I get #NAME? I arrived at the $633.33 by the formula
=7600/12.
But I need the dollar amount to round up to the nearest $10 each time I
put
in the latter formula. Can you help?



it works for me fine with decimals

you need to make sure you have all you addins ticked (under the tools
menu)


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=568448