Try this:

=IF(OR($J740,$K$22="QS"),$J74,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Pat" wrote in message
...
=IF(OR($J740,$K$22="QS"),0,$J74)

the above formula should display the value from J74 when QS is displayed in
K22
Could someone tell me why I am not getting a result.

Thanks