Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i am creating an work order with pricing. the overall size breaks down into
many parts of different sizes. i use square footage and linear measurments. right now i've got all the pricing formulas figured out for each part (for the exact sizes used), but i need the overall size to be rounded up to increments of 6. for example the overall size is 58" x 32" part #5: size is 26 1/2" x 30 1/4" (calculated in sq ft) cost of part #5 is 4.5/sqft so the formula i'm using is =(26.5*30.25/144)*4.5 but i need the the overall size to be rounded up to the next 6" increment in order for each part to be PRICED correct - but CAN'T change the sizes on my work order so part#5 needs to be priced as if the overall size is 60 x 36 (the part size would then be 27 1/2" x 34 1/4" help please :( |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: Round formula up in $5. increments =+(M4*1.1)+M4 | Excel Worksheet Functions | |||
extend my formula with increments of 4 cells | Excel Worksheet Functions | |||
Need formula to add increments of 0.16 seconds to time | Excel Discussion (Misc queries) | |||
How do I sum a formula and paste it in 7 cell increments? | Excel Discussion (Misc queries) | |||
formula for defining axis maximum and increments | Charts and Charting in Excel |