IF cell does not equal
 

How do I do this:

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

Thank you.
--
David P.

IF cell does not equal
 

Like this:

=if(a1<"apple",...)

Regards,
Fred.

"David P." wrote in message
...
How do I do this:

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

Thank you.
--
David P.

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

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.