Like this:

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

--
Biff
Microsoft Excel MVP


"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)