K
Kathleen_klr
What would the formula be to roundup a dollar amount to the nearest $10
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Elkar
Try this:
=ROUNDUP(A1,-1)
HTH,
Elkar
=ROUNDUP(A1,-1)
HTH,
Elkar
M
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
whereby 10 is the multiple you want (you can change this)
eg
=MROUND(F17,10)
eg
if F17 = 13 value = 1
K
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?
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?
K
Kathleen_klr
M
mr_ben
Kathleen_klr said: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