|
Result not being returned
=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 |
Try =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 |
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 |
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 |
| All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com