Thread: NOT equal to
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
  
Posts: 1,091
Default NOT equal to
Use the not equal operator, <. IF(A1<"Yes",True,False)

Tyro

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




Reply With QuoteReply With Quote