| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I need to round up to the nearest 50.
I am trying to calculate the number of raw material bags I need in a batch.
If I use the mround function is will round down. Is there a way to only round up? |
|
#2
|
|||
|
|||
|
=ROUNDUP(A21/50,0)*50
or =CEILING(A21,50) -- HTH Bob Phillips "karenm" wrote in message ... I am trying to calculate the number of raw material bags I need in a batch. If I use the mround function is will round down. Is there a way to only round up? |
|
#3
|
|||
|
|||
|
Hi karenm,
First of all, I believe MROUND rounds number according to the mathematical rules, not just DOWN or UP. You can use the following formulae for your case: =ROUNDUP(A1/50,0)*50 =CEILING(A1/50,1)*50 Regards, KL "karenm" wrote in message ... I am trying to calculate the number of raw material bags I need in a batch. If I use the mround function is will round down. Is there a way to only round up? |
|
#4
|
|||
|
|||
|
Opps!
The second formula should actually read: =CEILING(A1,50) KL "KL" wrote in message ... Hi karenm, First of all, I believe MROUND rounds number according to the mathematical rules, not just DOWN or UP. You can use the following formulae for your case: =ROUNDUP(A1/50,0)*50 =CEILING(A1/50,1)*50 Regards, KL "karenm" wrote in message ... I am trying to calculate the number of raw material bags I need in a batch. If I use the mround function is will round down. Is there a way to only round up? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round a number to the Nearest .25 | Excel Worksheet Functions | |||
| How do i round up a price to the nearest 5,10,15 etc pence | Excel Worksheet Functions | |||
| i need an excell formula that will round up to the nearest 9.99 | Excel Worksheet Functions | |||
| Round Up to Nearest 10 | Excel Worksheet Functions | |||
| Round time to nearest quarter hr | Excel Worksheet Functions | |||
Linear Mode
