| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
round up numbers to next highest "4"
I ship a product that must go out in boxes of 4. To save the warehouse
personel the trouble of calculating out the number of product they will need to stage for the next day I would like to write a formula/macro that will perform the following changes: 19 = 20 24 = 24 30 = 32 7 = 8 11 = 12 60 = 60 81 = 84 ect. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
round up numbers to next highest "4"
Try this:
A1: (some number) B1: =CEILING(A1,4) Does that help? *********** Regards, Ron "Jaisenm" wrote: I ship a product that must go out in boxes of 4. To save the warehouse personel the trouble of calculating out the number of product they will need to stage for the next day I would like to write a formula/macro that will perform the following changes: 19 = 20 24 = 24 30 = 32 7 = 8 11 = 12 60 = 60 81 = 84 ect. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Hightlighting Numbers & then all Cells to the right of these Numbers. | Excel Worksheet Functions | |||
| Why does a spreadsheet sent in Excel round numbers when mailed? | New Users to Excel | |||
| Can you round numbers to display a specific set of numbers, for e. | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Linear Mode
