Multiple Conditions and Multiple Solutions

G

Guest

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+

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
 
F

Frank Kabel

Hi Richard
try
=IF(A1="O",B1*C1,IF(A1="F",D1,IF(A1="D",B1+C1,"no solution")))

HTH
Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I have two conditions in a SUMIF? 5
Scrabble Value calculation for Welsh words 0
SUMIF with multiple conditions 3
sumif with multiple sums 3
Average with Conditions 1
Multiple Sumif conditions 2
Excel Subtracting multiple columns from another column 3
Calculate total by row number 4

Top