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