Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Write an Excel Formula Question
What would the formula be to roundup a dollar amount to the nearest $10
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about a formula (Excel XP) | New Users to Excel | |||
An Excel Formula Question | Excel Worksheet Functions | |||
Excel Formula Question | Excel Discussion (Misc queries) | |||
How do I write an Excel formula that re-calculates every 24 hrs? | Excel Discussion (Misc queries) | |||
how write excel formula numbers in column => &=< between 20-40 | New Users to Excel |