condition formula

[gop365]

looking fo a statement to pull from 3 variables.

A B C D E F G
9ga. x 8 3/4 x 120 = weight.
10ga. x 8 3/4 x 120 = weight
1/4 x 10 x 120 = weight.

threre are 3 possible entries for the first column all ...9ga. 10ga. and any standard number. I would like to make a statement in G1 to say...
If A1=9ga. then G1=9ga.calcualtion
If A1=10ga. then G1=10ga.calculation
If A1=any standard number then G1=0.2836*A1*C1*E1

the 9 and 10 gauge calcs are lengthy but will actually be math statements not text.

 

[Dimli]

Try..
=if(A1="9ga",calculation1,if(A1="10ga",calculation2,calculation3))
Will that work?

 

[gop365]

thank you, but for some reason excel reads two of the three commands. this is the problem i have been running into

 

[Dimli]

try posting part of the sheet to show the problem