Nesting the roundup Function in a larger formula

  • Thread starter Thread starter boxarox
  • Start date Start date
B

boxarox

=((((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?
 
=((((PI()*E22)*1.3)*0.377))*(CEILING(H22/J20))*TotalCaisson

or, with unnecessary parentheses removed
=PI()*E22*1.3*0.377*CEILING(H22/J20)*TotalCaisson

best wishes--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
 
=((((PI()*E22)*1.3)*0.377))*(CEILING(H22/J20))*TotalCaisson

or, with unnecessary parentheses removed
=PI()*E22*1.3*0.377*CEILING(H22/J20)*TotalCaisson

best wishes--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
 
Bernard has given you the answer you asked for, but I have a question for my
own curiosity. You said E22 contained the circumference, so why are you
multiplying by PI? Now, if E22 held the diameter, then I could understand
multiplying by PI as PI*Diameter is the formula for circumference, but you
said you already have the circumference; so what is the multiplication by PI
doing?
 
Bernard has given you the answer you asked for, but I have a question for my
own curiosity. You said E22 contained the circumference, so why are you
multiplying by PI? Now, if E22 held the diameter, then I could understand
multiplying by PI as PI*Diameter is the formula for circumference, but you
said you already have the circumference; so what is the multiplication by PI
doing?
 
Looks like you forgot to include the significance argument in the CEILING
function:

=PI()*E22*1.3*0.377*CEILING(H22/J20,1)*TotalCaisson
 
Looks like you forgot to include the significance argument in the CEILING
function:

=PI()*E22*1.3*0.377*CEILING(H22/J20,1)*TotalCaisson
 
Good eye Rick-- I had the math right, but wrote down the wrong description!
E22 actually contains the diameter. Thanks for your help.
 
Good eye Rick-- I had the math right, but wrote down the wrong description!
E22 actually contains the diameter. Thanks for your help.
 
Thanks Bernard but We need to set the argument in the "Ceiling" portion of
the formula to "1".
 
Thanks Bernard but We need to set the argument in the "Ceiling" portion of
the formula to "1".
 
Back
Top