Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting the roundup Function in a larger formula
=((((PI()*E22)*1.3)*0.377))*((H22/J20))*TotalCaisson
This is a formula for calculating the total weight of #3 rebar ties on a caisson Where E22=Caisson circumfrence in feet Where 1.30= the additional length required for overlap Where .377= the weight per foot of the tie. where H22 = Caisson Depth in feet where J20 = the rebar tie spacing in feet where TotalCaisson= the number caissons in the project of the given circumfrence I need to modify the formula so returns a whole number in the results of the H22/J20 portion of the calculation. So if the spacing of the ties is say, 1.17 feet and the depth of the caisson is 10 feet , the results of this portion of the formula is 9 rather than 8.547. (always rounded up to the next whole number) Can you help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Roundup Function | Excel Discussion (Misc queries) | |||
roundup function | Excel Discussion (Misc queries) | |||
ROUNDUP Function | Excel Discussion (Misc queries) | |||
Roundup Function | Excel Worksheet Functions | |||
Roundup Function | Excel Discussion (Misc queries) |