Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if stmt trouble
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*2 31)/(0.7854*B7^2),IF(AND(D7="Straight Side",D8="Gallons"),((B8*231)/(0.7854*B7))^0.5,IF(AND(D7="Gallons",D8="Straight Side"),((231*B7)/(0.7854*B8))^0.5,IF(AND(D7="O.D.",D8="Straight 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 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: http://www.excelforum.com/member.php...o&userid=31868 View this thread: http://www.excelforum.com/showthread...hreadid=516346 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
if stmt trouble
Look he
http://www.cpearson.com/excel/nested.htm -- Kind regards, Niek Otten "vencopbrass" wrote in message ... 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*2 31)/(0.7854*B7^2),IF(AND(D7="Straight Side",D8="Gallons"),((B8*231)/(0.7854*B7))^0.5,IF(AND(D7="Gallons",D8="Straight Side"),((231*B7)/(0.7854*B8))^0.5,IF(AND(D7="O.D.",D8="Straight 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 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: http://www.excelforum.com/member.php...o&userid=31868 View this thread: http://www.excelforum.com/showthread...hreadid=516346 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
if stmt trouble
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! "vencopbrass" wrote: 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*2 31)/(0.7854*B7^2),IF(AND(D7="Straight Side",D8="Gallons"),((B8*231)/(0.7854*B7))^0.5,IF(AND(D7="Gallons",D8="Straight Side"),((231*B7)/(0.7854*B8))^0.5,IF(AND(D7="O.D.",D8="Straight 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 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: http://www.excelforum.com/member.php...o&userid=31868 View this thread: http://www.excelforum.com/showthread...hreadid=516346 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UGH! Trouble downloading, and opening anything | Excel Discussion (Misc queries) | |||
Time Sheet for my org Im still having trouble | Excel Discussion (Misc queries) | |||
trouble shooting section | Excel Discussion (Misc queries) | |||
Trouble with Dates between 2 seperate worksheets | Excel Discussion (Misc queries) | |||
Graphing Trouble | Excel Discussion (Misc queries) |