Write an Excel Formula Question
 

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

Write an Excel Formula Question
 

Try this:

=ROUNDUP(A1,-1)

HTH,
Elkar


"Kathleen_klr" wrote:

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

Write an Excel Formula Question
 

mround is your friend

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

eg

=MROUND(F17,10)

eg

if F17 = 13 value = 10


--
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

Write an Excel Formula Question
 

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?

"mr_ben" wrote:


mround is your friend

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

eg

=MROUND(F17,10)

eg

if F17 = 13 value = 10


--
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

Write an Excel Formula Question
 

PERFECT! THANKS!
Kathleen

"Elkar" wrote:

Try this:

=ROUNDUP(A1,-1)

HTH,
Elkar


"Kathleen_klr" wrote:

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

Write an Excel Formula Question
 

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