Hi all,
I'm using the following formula to tell me whether or not services are provided at certain locations or not. The issue that I am having is that whenever any of the cells are blank, it automatically populates as "Yes" (because the values are not being met since the cell is blank). Can someone please tell me how I can amend this formula, so that it ignores any blank cells?
=IF(AND(OR(T2="No",U2="Other"),OR(AD2="No",AE2="Other"),OR(AZ2="NO",BA2="Other"),OR(BJ2="NO",BK2="Other"),OR(BT2="NO",BU2="Other"),OR(CD2="NO",CE2="Other"),OR(CN2="NO",CO2="Other"),OR(CX2="NO",CY2="Other"),OR(DH2="NO",DI2="Other"),OR(DR2="NO",DS2="Other"),OR(EA2="NO",EB2="Other"),OR(EJ2="NO",EK2="Other"),OR(ES2="NO",ET2="Other"),OR(FB2="NO",FC2="Other")),"No","Yes")
Many thanks in advance!
I'm using the following formula to tell me whether or not services are provided at certain locations or not. The issue that I am having is that whenever any of the cells are blank, it automatically populates as "Yes" (because the values are not being met since the cell is blank). Can someone please tell me how I can amend this formula, so that it ignores any blank cells?
=IF(AND(OR(T2="No",U2="Other"),OR(AD2="No",AE2="Other"),OR(AZ2="NO",BA2="Other"),OR(BJ2="NO",BK2="Other"),OR(BT2="NO",BU2="Other"),OR(CD2="NO",CE2="Other"),OR(CN2="NO",CO2="Other"),OR(CX2="NO",CY2="Other"),OR(DH2="NO",DI2="Other"),OR(DR2="NO",DS2="Other"),OR(EA2="NO",EB2="Other"),OR(EJ2="NO",EK2="Other"),OR(ES2="NO",ET2="Other"),OR(FB2="NO",FC2="Other")),"No","Yes")
Many thanks in advance!