S Santosh Kumar Srivastava Joined Jan 21, 2017 Messages 1 Reaction score 0 Jan 21, 2017 #1 What is the error in my formula : =if(c2=Se,"","",IF(F220="","","A/C Payee"))
Becky Webmistress Joined Mar 25, 2003 Messages 7,424 Reaction score 1,511 Jan 21, 2017 #2 You had too many arguments in your first IF function and needed quote marks around the 'Se'. Here's the corrected formula: =IF(C2="Se","",IF(F220="","","A/C Payee"))
You had too many arguments in your first IF function and needed quote marks around the 'Se'. Here's the corrected formula: =IF(C2="Se","",IF(F220="","","A/C Payee"))