Write an Excel Formula Question

[Guest]

What would the formula be to roundup a dollar amount to the nearest $10

 

[Guest]

Try this:

=ROUNDUP(A1,-1)

HTH,
Elkar

 

[mr_ben]

mround is your friend

whereby 10 is the multiple you want (you can change this)

eg

=MROUND(F17,10)

eg

if F17 = 13 value = 1

 

[Guest]

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?

 

[Guest]

PERFECT! THANKS!
Kathleen

Try this:

=ROUNDUP(A1,-1)

HTH,
Elkar

 

[mr_ben]

Mr. Ben,
Thank you for your reply. However, I used this number $633.33, when
use
your formula I get #NAME? I arrived at the $633.33 by the formul
=7600/12.
But I need the dollar amount to round up to the nearest $10 each time
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 tool
menu