HOW DO I CALCULATE SUFACE AREA DEPENDENT ON SHAPE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to build a spread sheet that will calculate the surface area of a
swimming pool by using the appropriate formula for the calculation. The
appropriate formula is dependent on the shape of the pool. If the entry in
B3 is "rectangle" I need a formula in H3 to multiply C3 by D3 where C3 and
D3 are the values for length and with respectively. If the entry in B3 is
"Circle" I need the formula in H3 to multiply C3/2*3.14
 
=if(b3="rectangle",c3*d3*c3,c3/2*3.24)
that will calculate the area for rectangle, and the area for circle for
anything else they enter in b3. If you want to specifically check for
"circle" you need to nest another if statement.
 
Hi Randy,

Does this get you there?

=IF(B3="rec",C3*D3,C3/2*3.14)

It's either a circle or a rectangle so the TRUE argument does the "rec" and
the FALSE argument does the circle formula.

HTH
Regards,
Howard
 
Thank You Marvin.
I intend to set up the formula to calculate for rectangle, circle, oblong,
oval, kidney etc. I think I can figure out how to nest the arguments.

Thank You for your help.

Randy
 
Hi!

I posted this elsewhere, but it isn't getting through to these
regions.(I believe Mr Rubin is working on it). Excuse any double
posting therefore, but wrong information is being used here.

The formula for the area of circle is (to put it in English) pi R
squared, where R is the radius.
In formula terms it is pi()*(C3/2)^2 where C3 holds the diameter of the
circle.

3.14 as a value for pi() is fine for this purpose.

=if(b3="rectangle",c3*d3,3.14*(c3­/2)^2) would do the job you asked
for.

Alf
 
Back
Top