V
vencopbrass
here is my current formula:
=ROUND(IF(AND(D7="Gallons",D8="O.D."),(B7*231)/(0.7854*B8^2),IF(AND(D7="O.D.",D8="Gallons"),(B8*231)/(0.7854*B7^2),IF(AND(D7="Straigh
Side",D8="Gallons"),((B8*231)/(0.7854*B7))^0.5,IF(AND(D7="Gallons",D8="Straigh
Side"),((231*B7)/(0.7854*B8))^0.5,IF(AND(D7="O.D.",D8="Straigh
Side"),(0.7854*B7^2*B8)/231,(0.7854*B8^2*B7)/231))))),4)
this was working great until I was asked to add another constraint.
This calculates diameter or height or gallons depending on what wa
entered. Problem is that this was set up for input of inches and no
the input can be either inches or feet. These formulas only work fo
inches. Now I need to check to see if the user inputed inches or fee
and I can't fit that many if statements into this.
Any suggestions?
I know theres a better way to do this, but am at a loss.
Thanks
Lis
=ROUND(IF(AND(D7="Gallons",D8="O.D."),(B7*231)/(0.7854*B8^2),IF(AND(D7="O.D.",D8="Gallons"),(B8*231)/(0.7854*B7^2),IF(AND(D7="Straigh
Side",D8="Gallons"),((B8*231)/(0.7854*B7))^0.5,IF(AND(D7="Gallons",D8="Straigh
Side"),((231*B7)/(0.7854*B8))^0.5,IF(AND(D7="O.D.",D8="Straigh
Side"),(0.7854*B7^2*B8)/231,(0.7854*B8^2*B7)/231))))),4)
this was working great until I was asked to add another constraint.
This calculates diameter or height or gallons depending on what wa
entered. Problem is that this was set up for input of inches and no
the input can be either inches or feet. These formulas only work fo
inches. Now I need to check to see if the user inputed inches or fee
and I can't fit that many if statements into this.
Any suggestions?
I know theres a better way to do this, but am at a loss.
Thanks
Lis