# condition formula

#### gop365

##### New Member
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.

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### Dimli

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

#### gop365

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

#### Dimli

##### Board Regular
try posting part of the sheet to show the problem

Replies
0
Views
382
Replies
1
Views
368
Replies
4
Views
430
Replies
2
Views
457
Replies
4
Views
273

1,181,785
Messages
5,932,031
Members
436,814
Latest member
Yurop

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back