=IF(OR(K2=“Chandigarh”,K2=“Pondicherry”,AD2=“Chandigarh”, AD2=“Pondicherry”),“”, R2)
same problem occur
=IF(OR(K2=“Chandigarh”,K2=“Pondicherry”,AD2=“Chandigarh”, AD2=“Pondicherry”),“”, R2)
same problem occur
Character constant contain one must character only & range doesnt exit