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.