View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw
 
Posts: n/a
Default If Statement Problem

are you using quotes?

=if(a1="word","xyz","")

(if it's not "word" cell is empty)