NOT equal to

[Neon520]

How to write the criteria in the formula as NOT EQUAL TO?

For example, =if(A1 is NOT equal to "YES", do something, else do something
else)

 

[Tyro]

Use the not equal operator, <>. IF(A1<>"Yes",True,False)

Tyro

 

[Rick Rothstein \(MVP - VB\)]

=IF(A1<>"YES","A1 is not Yes","A1 equals Yes")

Rick

 

[MartinW]

Hi Neon,

<> is the symbol for not equal to

HTH
Martin

 

[T. Valko]

Like this:

=IF(A1<>"Yes",do_something,do_someting_else)

 

[Neon520]

THANKS FOR THE RAPID REPLY, EVERYONE!!!
YOU GUYS HAVE BEEN REALLY HELPFUL!!!