View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default equals something

Try:

=IF(A1<"","something", "null(or empty)")

"<" means "not equal to" / "does not equal"

so above test if A1 does not equal NULL (empty) i.e. equals something

HTH

"Mike" wrote:

Okay, I know how to say "When a cell equals nothing" (="", or =0), but how
would I say "When a cell equals something", whether a letter, symbol,
number... anything?

Please help!