D Dave Peterson Jan 12, 2010 #2 First, the formula has to go into T2: =if(a2=c1,s2,"not equal") replace that "not equal" string with what you want to see if A2 doesn't equal C1.
First, the formula has to go into T2: =if(a2=c1,s2,"not equal") replace that "not equal" string with what you want to see if A2 doesn't equal C1.