formular IF and or

Christine Menke

Hi Experts,

I use a formula on different sheets and it works on 4 sheets but on this one it's shown the wrong results. I could not find the mistake. Could you please have a look.

Here is my formula:

=IF(AND(OR([CR0 Planned ex-factory date AC-T samples]@row = "", [CR0 Actual ex-factory date AC-T samples]@row = ""), [CR0 AC-T sample needed?]@row = "yes"), "Yellow", IF(AND([CR0 Actual ex-factory date AC-T samples]@row < DATE(2023, 1, 18), [CR0 AC-T sample needed?]@row = "yes"), "Green", IF(AND([CR0 AC-T sample needed?]@row = "", [CR0 Actual ex-factory date AC-T samples]@row = ""), "not needed", IF(AND([CR0 AC-T sample needed?]@row = "yes", [CR0 Actual ex-factory date AC-T samples]@row <> "", [CR0 Planned ex-factory date AC-T samples]@row <> "", [CR0 Actual ex-factory date AC-T samples]@row >= DATE(2023, 1, 18)), "Red"))))

And the result: But in the yellow frame cells the result should be a yellow dot. And if I put in a date in "CR0 Actual ex-.....) the result is an empty cell.

Thanks for your help!

Christine Menke

Oh I just logged in again and now the result is correct :-)

Andrée Starå

Hi @Christine Menke

I hope you're well and safe!

Glad you got it working!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!