View Single Post
  #1   Report Post  
Pat
 
Posts: n/a
Default Tje opposite appears to be happening

The following formula should only return a result if K19 contains "QS"

=IF($B111=CHAR(252),$N111,IF(AND($N1110,$K$19="QS "),0,$N111))

The opposite appears to be happening, why should this be?

Thank U if you can help.
Pat