Hello, I am trying to create a formula that reflects a Low, Medium, High matrix and I'm having a harder time than I anticipated. I can't figure it out for the life of me. I feel like I'm on the wrong track...
I | J | K | |
1 | List (Low, Medium, High) | List (Low, Medium, High) | =IF(I2=Low, AND(J2=Low), "Low), OR(I2=Low), AND(J2=Medium), "Low) |
2 | Low | Low | Low |
3 | Low | Medium | Low |
4 | Low | High | High |
5 | Medium | High | High |