Combining if & or function

[fiera150]

=OR(IF(C2="GOOD",K2,""),IF(D2="GOOD",M2,""))

This is what I tried, but it was not right.

I want the values from K2 if C2 is "GOOD" or the values from M2 if D2 is "GOOD". How to formulate this?

It seems simple, but I couldn't do it. I would really appreciate some help here.

Thank you.

[Bob Phillips]

Try

=IF(C2="GOOD",K2,IF(D2="GOOD",M2,""))

[bonny24tycoon]

Hi fiera150,

What if both conditions are not met.. I mean what should it be if C2 or D2 isnt Good?

[Fotis1991]

Hi


Delete post

[bonny24tycoon]

Hi fiera150,

Try this

Please Login or Register  to view this content.

You can add text or value or cell refrence in the brackets after M2.

If I was able to help – PLEASE DO NOT FORGET to Click the small star icon at the bottom left of my post.

[fiera150]

Bob,
Thank you, it works.

Bonny,
If the conditions are not met, leave the cell blank.

Thank you, it works.

Thank you so much guys...