software

here is my current formula:
=ROUND(IF(AND(D7=quot;Gallonsquot;,D8=quot;O.D.quot;),(B7*231)/(0.7854*B8^2),IF(AND(D7=quot;O.D.quot;,D8=quot;Gallonsquot;),(B8*2 31)/(0.7854*B7^2),IF(AND(D7=quot;Straight
Sidequot;,D8=quot;Gallonsquot;),((B8*231)/(0.7854*B7))^0.5,IF(AND(D7=quot;Gallonsquot;,D8=quot;Straight
Sidequot;),((231*B7)/(0.7854*B8))^0.5,IF(AND(D7=quot;O.D.quot;,D8=quot;Straight
Sidequot;),(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 was
entered. Problem is that this was set up for input of inches and now
the input can be either inches or feet. These formulas only work for
inches. Now I need to check to see if the user inputed inches or feet
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
Lisa--
vencopbrass
------------------------------------------------------------------------
vencopbrass's Profile: www.excelforum.com/member.php...oamp;userid=31868
View this thread: www.excelforum.com/showthread...hreadid=516346Look he

www.cpearson.com/excel/nested.htm

--
Kind regards,

Niek Otten

quot;vencopbrassquot; gt;
wrote in message
...
gt;
gt; here is my current formula:
gt; =ROUND(IF(AND(D7=quot;Gallonsquot;,D8=quot;O.D.quot;),(B7*231)/(0.7854*B8^2),IF(AND(D7=quot;O.D.quot;,D8=quot;Gallonsquot;),(B8*2 31)/(0.7854*B7^2),IF(AND(D7=quot;Straight
gt; Sidequot;,D8=quot;Gallonsquot;),((B8*231)/(0.7854*B7))^0.5,IF(AND(D7=quot;Gallonsquot;,D8=quot;Straight
gt; Sidequot;),((231*B7)/(0.7854*B8))^0.5,IF(AND(D7=quot;O.D.quot;,D8=quot;Straight
gt; Sidequot;),(0.7854*B7^2*B8)/231,(0.7854*B8^2*B7)/231))))),4)
gt;
gt; this was working great until I was asked to add another constraint.
gt; This calculates diameter or height or gallons depending on what was
gt; entered. Problem is that this was set up for input of inches and now
gt; the input can be either inches or feet. These formulas only work for
gt; inches. Now I need to check to see if the user inputed inches or feet
gt; and I can't fit that many if statements into this.
gt; Any suggestions?
gt; I know theres a better way to do this, but am at a loss.
gt; Thanks
gt; Lisa
gt;
gt;
gt; --
gt; vencopbrass
gt; ------------------------------------------------------------------------
gt; vencopbrass's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31868
gt; View this thread: www.excelforum.com/showthread...hreadid=516346
gt;
you could alter your input cells to include feet and have a helper cell
convert to inches,add to the inches cell and have your formula look at the
helper cell.
--
paul
remove nospam for email addy!
quot;vencopbrassquot; wrote:

gt;
gt; here is my current formula:
gt; =ROUND(IF(AND(D7=quot;Gallonsquot;,D8=quot;O.D.quot;),(B7*231)/(0.7854*B8^2),IF(AND(D7=quot;O.D.quot;,D8=quot;Gallonsquot;),(B8*2 31)/(0.7854*B7^2),IF(AND(D7=quot;Straight
gt; Sidequot;,D8=quot;Gallonsquot;),((B8*231)/(0.7854*B7))^0.5,IF(AND(D7=quot;Gallonsquot;,D8=quot;Straight
gt; Sidequot;),((231*B7)/(0.7854*B8))^0.5,IF(AND(D7=quot;O.D.quot;,D8=quot;Straight
gt; Sidequot;),(0.7854*B7^2*B8)/231,(0.7854*B8^2*B7)/231))))),4)
gt;
gt; this was working great until I was asked to add another constraint.
gt; This calculates diameter or height or gallons depending on what was
gt; entered. Problem is that this was set up for input of inches and now
gt; the input can be either inches or feet. These formulas only work for
gt; inches. Now I need to check to see if the user inputed inches or feet
gt; and I can't fit that many if statements into this.
gt; Any suggestions?
gt; I know theres a better way to do this, but am at a loss.
gt; Thanks
gt; Lisa
gt;
gt;
gt; --
gt; vencopbrass
gt; ------------------------------------------------------------------------
gt; vencopbrass's Profile: www.excelforum.com/member.php...oamp;userid=31868
gt; View this thread: www.excelforum.com/showthread...hreadid=516346
gt;
gt;