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?