Result not being returned

[Pat]

=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

 

[RagDyeR]

Try this:

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

HTH,

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


=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

 

[ilanr01]

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

 

[Pat]

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]

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

 

[RagDyeR]

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


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.

 

[Pat]

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

 

[Pat]

Thank you RagDyeR that fixed it.

Cheers to both of you
Pat

 

[RagDyeR]

Appreciate the feed-back.
--

Regards,

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

Thank you RagDyeR that fixed it.

Cheers to both of you
Pat