=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

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

I am not sure what the "Or" is doing here, but try this
=IF(OR($J740,$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.


wrote in message
ups.com...
I am not sure what the "Or" is doing here, but try this
=IF(OR($J740,$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($J740,$K$22="QS"),$J74,0)
--

HTH,

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


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


wrote in message
ups.com...
I am not sure what the "Or" is doing here, but try this
=IF(OR($J740,$K$22="QS"),$J74,0)
Ilan

Thank you RagDyeR that fixed it.

Cheers to both of you
Pat


"RagDyeR" wrote in message
...
If you want a return *only* when K22 contains "QS",
*AND* when J74 is greater then zero,
Change the "OR" to "AND",

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

HTH,

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


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


wrote in message
ups.com...
I am not sure what the "Or" is doing here, but try this
=IF(OR($J740,$K$22="QS"),$J74,0)
Ilan

Appreciate the feed-back.
--

Regards,

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

"Pat" wrote in message
...
Thank you RagDyeR that fixed it.

Cheers to both of you
Pat


"RagDyeR" wrote in message
...
If you want a return *only* when K22 contains "QS",
*AND* when J74 is greater then zero,
Change the "OR" to "AND",

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

HTH,

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


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


wrote in message
ups.com...
I am not sure what the "Or" is doing here, but try this
=IF(OR($J740,$K$22="QS"),$J74,0)
Ilan

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

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

wrote in message
ups.com...
Try =IF(OR($J740,$K$22="QS"),$J74,0)
Ilan