Thread: NOT equal to
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default NOT equal to
=IF(A1<"YES","A1 is not Yes","A1 equals Yes")

Rick


"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