IF Statement

[Rocksie]

Good day,

I have a scenario where the formula must look at four different scenarios and return a value based on which is true.
I have the following formula and it works correctly up to scenario 2, but scenario 3 & 4 gives me a "False" value:

=IF(B15="More than 15 min";IF(C15="YES";IF(D15="YES";"YES");IF(B15="More than 15 min";IF(C15="NO";IF(D15="NO";"NO");IF(B15="More than 15 min";IF(C15="NO";IF(D15="YES";"NO");IF(B15="More than 15 min";IF(C15="YES";IF(D15="NO";"YES")))))))))

	More than 15 min	YES	YES		YES
	More than 15 min	NO	NO		NO
	More than 15 min	NO	YES		FALSE
	More than 15 min	YES	NO		FALSE

Any help on how to rectify it would be appreciated.

Thank you,
Rocco

 

[arthurbr]

Perhaps =if(and(B15="More than 15 min";and(c15="yes";or(d15="yes";d15="no")));"yes";"no")

 

[gaz_chops]

What are you trying to do?
It looks like if B15="More than 15 min" and C15="Yes" then "Yes", else "No".
Is that correct?

 

[gaz_chops]

Doesn't this work!

=IF(B15="More than 15 min",IF(C15="YES","YES","No"))

 

[Rocksie]

There are 4 different scenario's: "Yes", "Yes" should return "No"; "No", "No" should return "No"; "No" "Yes"should return "No" and "Yes" "No" should return "Yes"

Hope it makes more sense now

 

[gaz_chops]

Did you try my solution?

There are only really 2 criteria, If C = Yes then Yes, If C = No then No.

 

[Fluff]

Is this correct? as it doesn't agree with your op

"Yes", "Yes" should return "No"

 

[Rocksie]

=if(and(B15="More than 15 min";and(c15="yes";or(d15="yes";d15="no")));"yes";"no")

Thank you Arthurbr, your solution worked for me!

 

[gaz_chops]

Does my simpler solution not do the same? It gives the same answers as far as i can see.