IF And Multiple condition in a statement formula

[Jyotirmaya]

I am using a formula =IF(AND(S4="NO",W4="YES"),V4,Q4) in this same cell I want to add another condition that IF(AND(S4="NO",V4="NO"),M4,0) how to add these two ??

 

[dreid1011]

You can try this:

=IF(AND(S4="NO",W4="YES"),V4,IF(AND(S4="NO",V4="NO"),M4,Q4))

 

[felixstraube]

I don't see how you could combine those conditions:

S4	W4	V4	Result		S4	W4	V4	Result
NO	NO	NO	Q4		NO	NO	NO	M4
NO	NO	YES	Q4		NO	NO	YES	0
NO	YES	NO	V4		NO	YES	NO	M4
NO	YES	YES	V4		NO	YES	YES	0
NO	NO	NO	Q4		NO	NO	NO	M4
NO	NO	YES	Q4		NO	NO	YES	0
NO	YES	NO	V4		NO	YES	NO	M4
NO	YES	YES	V4		NO	YES	YES	0
YES	NO	NO	Q4		YES	NO	NO	0
YES	NO	YES	Q4		YES	NO	YES	0
YES	YES	NO	Q4		YES	YES	NO	0
YES	YES	YES	Q4		YES	YES	YES	0
YES	NO	NO	Q4		YES	NO	NO	0
YES	NO	YES	Q4		YES	NO	YES	0
YES	YES	NO	Q4		YES	YES	NO	0
YES	YES	YES	Q4		YES	YES	YES	0

From your first IF you have the first truth table. From the second the second table. They are overlapping.
For example if you have S4 = NO, W4 = NO and V4 = NO. From the first IF / truth table you will return Q4, but from the second you would return M4. So which should it be?
I think there is another condition missing or something.
Maybe you can explain what those conditions mean and what your expected result should be?

 

[dreid1011]

Nevermind.