May 19 2023 01:33 PM - edited May 19 2023 01:36 PM
Hello, I need to be able to use this formula more than once (at least 3 times) nested, in the same cell to check for multiple conditions. Or something similar. I have 3 sets of conditions for blue belt, the formula needs to be able to check for all 3 conditions to see if learner has achieved a blue belt......=IF(OR(AND(R3=A3,S3=A3), AND(P3=A3,J3=A3,Q3=A3)),"Blue Belt","N")
May 19 2023 01:56 PM
May 19 2023 02:47 PM
Thanks for your reply!
Yes the testing is like this:
If cells P3, J3, Q3 AND 1 of these cells (R3, S3, T3) equals A3, then Blue Belt.
Next, If cell U3 AND 1 of these cells (R3, S3, T3) equals A3, then Blue Belt.
Then If cells V3, W3, X3, Q3, equals A3, then Blue Belt.
There are 3 paths to blue belt and I need to be able to check for them all in one cell/formula.
Hope that clarifies! :)