View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default IF cell does not equal

On Fri, 12 Dec 2008 15:48:01 -0800, David P.
wrote:

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