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?

Nesting the roundup Function in a larger formula
 

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

"boxarox" wrote in message
...
=((((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?

Nesting the roundup Function in a larger formula
 

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?

--
Rick (MVP - Excel)


"boxarox" wrote in message
...
=((((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?

Nesting the roundup Function in a larger formula
 

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

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


--
Biff
Microsoft Excel MVP


"Bernard Liengme" wrote in message
...
=((((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

"boxarox" wrote in message
...
=((((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?

Nesting the roundup Function in a larger formula
 

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

"Rick Rothstein" wrote:

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?

--
Rick (MVP - Excel)


"boxarox" wrote in message
...
=((((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?

Nesting the roundup Function in a larger formula
 

"Bernard Liengme" wrote:

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

"boxarox" wrote in message
...
=((((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?

Nesting the roundup Function in a larger formula
 

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

"Bernard Liengme" wrote:

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

"boxarox" wrote in message
...
=((((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?

Nesting the roundup Function in a larger formula
 

The subject of this post is right up your alley, isn't it?

--
Biff
Microsoft Excel MVP


"Rick Rothstein" wrote in message
...
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?

--
Rick (MVP - Excel)


"boxarox" wrote in message
...
=((((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?

Nesting the roundup Function in a larger formula
 

Whatever do you mean? <g

--
Rick (MVP - Excel)


"T. Valko" wrote in message
...
The subject of this post is right up your alley, isn't it?

--
Biff
Microsoft Excel MVP


"Rick Rothstein" wrote in message
...
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?

--
Rick (MVP - Excel)


"boxarox" wrote in message
...
=((((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?