Write an Excel Formula Question

[Kathleen_klr]

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

[Elkar]

Try this:

=ROUNDUP(A1,-1)

HTH,
Elkar


"Kathleen_klr" wrote:

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

[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 = 10

[Kathleen_klr]

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

[Kathleen_klr]

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

[mr_ben]

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)