Adding 4 formulas to 1 cell with 'OR'

[ste33uka]

Hi could someone combine these 4 formulas so they can go into 1 cell ?
Maybe using 'OR'
=IF(AND(A4="YES",B4="YES",C4>5,C4<10),C1,"")
=IF(AND(A4="YES",B4="YES",C4>10,C4<15),D1,"")
=IF(AND(A4="YES",B4="NO",C4>5,C4<10),E1,"")
=IF(AND(A4="YES",B4="NO",C4>10,C4<15),F1,"")

 

[JimM]

You could just nest them

=IF(AND(A4="YES",B4="YES",C4>5,C4<10),C1,IF(AND(A4="YES",B4="YES",C4>10,C4<15),D1,IF(AND(A4="YES",B4="NO",C4>5,C4<10),E1,IF(AND(A4="YES",B4="NO",C4>10,C4<15),F1,""))))

 

[etaf]

theres probably a simpler way
BUT a Nested IF
=IF(AND(A4="YES",B4="YES",C4>5,C4<10),C1,IF(AND(A4="YES",B4="YES",C4>10,C4<15),D1,IF(AND(A4="YES",B4="NO",C4>5,C4<10),E1,IF(AND(A4="YES",B4="NO",C4>10,C4<15),F1,""))))

 

[ste33uka]

theres probably a simpler way
BUT a Nested IF
=IF(AND(A4="YES",B4="YES",C4>5,C4<10),C1,IF(AND(A4="YES",B4="YES",C4>10,C4<15),D1,IF(AND(A4="YES",B4="NO",C4>5,C4<10),E1,IF(AND(A4="YES",B4="NO",C4>10,C4<15),F1,""))))

Thanks alot, that works for me

 

[Bo_Ry]

Please try
=IF(AND(A4="YES",C4<15,C4>5),INDEX(C1:F1,2-(C4<10)+(B4="No")*2),"")