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,"")
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,"")