If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple Conditions and Multiple Solutions
Hi Richard
try =IF(A1="O",B1*C1,IF(A1="F",D1,IF(A1="D",B1+C1,"no solution"))) HTH Frank Richard wrote: I am trying to work out a formula for multiple conditions and multiple solutions. ie.. If column A=O, solution= Column B*C, If column A=F, Solution=D, If column A=D, solution=B+C And so on. IS there a way to have multiple conditions and multiple reactions (solutions)? I have tried the SUMIF formula. =SUMIF(D2011, "D", A2011+C2011) I can get one condition to work, but not multiples. |
Thread Tools | |
Display Modes | |
|
|