Appreciate the feed-back.
--

Regards,

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

"Pat" <glass_patrick@hotmail.com> wrote in message
news:%23Te4CoqFFHA.4016@TK2MSFTNGP09.phx.gbl...
Thank you RagDyeR that fixed it.

Cheers to both of you
Pat


"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:OfAqLhqFFHA.2508@TK2MSFTNGP10.phx.gbl...
> If you want a return *only* when K22 contains "QS",
> *AND* when J74 is greater then zero,
> Change the "OR" to "AND",
>
> =IF(AND($J74>0,$K$22="QS"),$J74,0)
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Pat" <glass_patrick@hotmail.com> wrote in message
> news:%234R4RZqFFHA.3648@TK2MSFTNGP10.phx.gbl...
> Hi gentlemen,
>
> A result is returned regardless if K22 contains QS or not. Something is
not
> right about this formula!
>
> > I am not sure what the "Or" is doing here
>
> The formula has been broken down, this is where the OR comes from.
>
>
> <ilanr01@yahoo.com> wrote in message
> news:1108832091.490237.83650@o13g2000cwo.googlegroups.com...
> > I am not sure what the "Or" is doing here, but try this
> > =IF(OR($J74>0,$K$22="QS"),$J74,0)
> > Ilan
> >
>
>
>