Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get MROUND to only round up to the next multiple.
I do not wish to get a lower number when rounding to a miltpile of it. I
need to combing the MROUND and ROUNDUP. |
#2
|
|||
|
|||
Answer: How do I get MROUND to only round up to the next multiple.
Sure, I can help you with that!
To round up to the next multiple using Code:
MROUND Code:
ROUNDUP
That's it! This formula will ensure that your number is always rounded up to the next multiple of 10. Let me know if you have any other questions!
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get MROUND to only round up to the next multiple.
gmac wrote...
I do not wish to get a lower number when rounding to a miltpile of it. I need to combing the MROUND and ROUNDUP. Don't use MROUND. Instead of =MROUND(x,n) use =ROUNDUP(x/n,0)*n |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get MROUND to only round up to the next multiple.
If x and n have the same sign you can also use =CEILING(x,n)
-- David Biddulph "Harlan Grove" wrote in message oups.com... Don't use MROUND. Instead of =MROUND(x,n) use =ROUNDUP(x/n,0)*n gmac wrote... I do not wish to get a lower number when rounding to a miltpile of it. I need to combing the MROUND and ROUNDUP. |
#5
|
|||
|
|||
=IF(MROUND(A1,x)<=A1,MROUND(A1,x)+x,MROUND(A1,x))
Will round A1 UP to the next number divisible by x. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I round numbers to the nearest multiple of 10 or 5? | Excel Worksheet Functions | |||
Round Up by a factor not by a digit [MROUNDUP(number,multiple)] | Excel Worksheet Functions | |||
Can MROUND be used to always round down? | Excel Discussion (Misc queries) | |||
Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
multiple and round | Excel Worksheet Functions |