=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
which is the error?
@babita
Character constant contain one must character only & range doesnt exit