J jsfannon New Member Feb 3, 2012 #1 I need help I have a current formula of =IF(L6=K6+I6,"YES","NO") the L colum also has text i was trying to combine a formula into the one above to state if text YES or true any help would be greatly appreciated.
I need help I have a current formula of =IF(L6=K6+I6,"YES","NO") the L colum also has text i was trying to combine a formula into the one above to state if text YES or true any help would be greatly appreciated.
SirJB7 Excel Rōnin Feb 3, 2012 #2 Hi, jsfannon! Try this: =IF(ISTEXT(L6),"YES",IF(L6=K6+I6,"YES","NO")) Regards!
