Perhaps

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pat" wrote in message
...
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