need an IF statement

[abelle82]

Is it possible to combine the following formulas into one cell?

=IF(AND(F2="", K2=1),"3/15/2016","9/15/2016")
=IF(AND(F2="", K2=2),"4/18/2016","9/15/2016")
=IF(AND(F2="", K2=3),"11/15/2016","5/15/2017")

[Teblol]

Hi abelle82,

Below is the closest I believe you can get. Now someone much better than me may be able to correct me if I am wrong however I do not believe you can have multiple "value if false" results. When you use if and, the formula takes the first set of instructions and if it is true it will return the "if true" value. However if it is not true it will move on to the "if false" value and uses whatever you have listed as the answer. The reason you can have a bunch of nested IF/AND statements is because you are telling the formula to move on to the next IF/AND statement if your original rule is false. The second you give a distinct value for the "if false" value the formula would end. I hope my explanation makes sense.

Please Login or Register  to view this content.

[Jacc]

No. If the AND condition is not met is different in the last one. How to know which one to use?

[Sam Capricci]

I think the problem you have is that with your first two conditions F2="" and K2=1 or 2, if it doesn't meet those conditions you've given it an alternative answer of 9/15/2016 so for your next set of conditions don't matter (F2="",K2=3).