Nesting the roundup Function in a larger formula

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?
 
B

Bernard Liengme

=((((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
 
R

Rick Rothstein

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?
 
T

T. Valko

Looks like you forgot to include the significance argument in the CEILING
function:

=PI()*E22*1.3*0.377*CEILING(H22/J20,1)*TotalCaisson
 
B

boxarox

Good eye Rick-- I had the math right, but wrote down the wrong description!
E22 actually contains the diameter. Thanks for your help.
 
B

boxarox

Thanks Bernard but We need to set the argument in the "Ceiling" portion of
the formula to "1".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the weighted average of text that have been given values 1
how can I set a fixed width font in the formula bar? 2
formula to make the value in a cell, to a row in a sum function 5
In a formula or function, what do the symbols "" mean. 3
How to use the rownumber of the current cell in a formula 3
Formula returning "A value used in the formula is of the wrong dat 2
function to count the number of cell references in a formula 4
formula that calc the diff in time, with a less than function? 1

Top