Thread: IF cell does not equal
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
  
Posts: 1,805
Default IF cell does not equal
Enter this anywhere other than A1
=IF(A1<"apple","A1 is not equal to apple","A1 contains apple")

"David P." wrote:

How do I do this:

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

Thank you.
--
David P.
Reply With QuoteReply With Quote