D Dileep Reddy Member Mar 31, 2014 #2 hi bhasoriya, i guess it should be =IF(C2 = "T.", 0,1) Regards Dileep
Somendra Misra Excel Ninja Mar 31, 2014 #3 Hi Bhasoriya, What is T.? If it is a named range than what is the ref. of it? Regards,