Result not being returned

=IF(OR($J74>0,$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

Try this:

=IF(OR($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:ObhppGqFFHA.560@TK2MSFTNGP15.phx.gbl...
=IF(OR($J74>0,$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

I am not sure what the "Or" is doing here, but try this
=IF(OR($J74>0,$K$22="QS"),$J74,0)
Ilan

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
>

Try =IF(OR($J74>0,$K$22="QS"),$J74,0)
Ilan

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
>

Unless I need glasses - your suggestion is identical to your last post.
Pat

<ilanr01@yahoo.com> wrote in message
news:1108833812.017320.41650@z14g2000cwz.googlegroups.com...
> Try =IF(OR($J74>0,$K$22="QS"),$J74,0)
> Ilan
>

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
> >
>
>
>

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
> >
>
>
>