Hi Neon,

< is the symbol for not equal to

HTH
Martin


"Neon520" wrote in message
...
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)