IF cell does not equal

L

Lars-Åke Aspelin

How do I do this:

=IF(cell A1 does not equal "apple"),...

Thank you.

Try this

=IF(A1<>"apple", something, somethingelse)

replace something and somethingelse with the the results you expect
for the different cases.

Hope this helps / Lars-Åke
 
S

Sheeloo

Enter this anywhere other than A1
=IF(A1<>"apple","A1 is not equal to apple","A1 contains apple")
 
Top