Multiple AND and OR statements with same outcome

[komhs]

Hi to all and thanks in advance for trying to help.

In the columns A, B, C, I have typed all the possible pair scenarios that I want to add to the D1 cell.

My problem is:

I want to type an IF formula to D1 Cell (in this particular circumstance, the outcome is "yes") with the following logical statement: If (A1=1 and B1 is -2,25 with C1<=-2 OR B1=-1,25 with C1=1 OR B1=-0,25 with C1=0 OR B1=0,75 with C1=-1 OR B1=1,75 with C1=-2 OR B1=2,75 with C1>=3) then "Yes". I don't have an "else" after "then", because I want to add more similar functions in D1 cell with some other pairs which have some other outcome (in this example it was "Yes").

	A	B	C	D
1​	1	-2,25	-2	"YES"
2​	1	-1,25	1	"YES"
3​	1	-0,25	0	"YES"
4​	1	0,75	-1	"YES"
5​	1	1,75	-2	"YES"
6​	1	2,75	3	"YES"

Thanks in advance for your help

 

[etaf]

nested IF
OR (
AND (A1=1 ,B1 = -2,25, C1<=-2 ),
AND( A1=1,B1=-1,25 ,C1=1 ),
AND( A1=1, B1=-0,25, C1=0 ),
AND( A1=1 , B1=0,75 , C1=-1 ),
AND(A1=1, B1=1,75 , C1=-2),
AND( A1=1,B1=2,75 ,C1>=3)
)

Add that to an IF
=IF ( OR ( AND (A1=1 ,B1 = -2,25, C1<=-2 ), AND( A1=1,B1=-1,25 ,C1=1 ), AND( A1=1, B1=-0,25, C1=0 ), AND( A1=1 , B1=0,75 , C1=-1 ), AND(A1=1,B1=1,75 , C1=-2), AND( A1=1,B1=2,75 ,C1>=3) ) , "Yes", IF( next test , True, False ))

 

[komhs]

nested IF
OR (
AND (A1=1 ,B1 = -2,25, C1<=-2 ),
AND( A1=1,B1=-1,25 ,C1=1 ),
AND( A1=1, B1=-0,25, C1=0 ),
AND( A1=1 , B1=0,75 , C1=-1 ),
AND(A1=1, B1=1,75 , C1=-2),
AND( A1=1,B1=2,75 ,C1>=3)
)

Add that to an IF
=IF ( OR ( AND (A1=1 ,B1 = -2,25, C1<=-2 ), AND( A1=1,B1=-1,25 ,C1=1 ), AND( A1=1, B1=-0,25, C1=0 ), AND( A1=1 , B1=0,75 , C1=-1 ), AND(A1=1,B1=1,75 , C1=-2), AND( A1=1,B1=2,75 ,C1>=3) ) , "Yes", IF( next test , True, False ))

Thank you so much for the solution!

 

[etaf]

you are welcome