I am trying to build a formula that will help with the following problem:
If A and B is Yes , then C = Mission Critical
If A is Yes and B is No, then C = Critical Impact Replacement
If A is No and B is Yes, then C = Scarce Non-Critical
If A is No and B is No, then C = Mass Market
I need to get this into one formulated cell. I have been struggling for several hours. I would love any advice. I have tried If and, If or, but I can only get the first problem solved, the rest error out.
If A and B is Yes , then C = Mission Critical
If A is Yes and B is No, then C = Critical Impact Replacement
If A is No and B is Yes, then C = Scarce Non-Critical
If A is No and B is No, then C = Mass Market
I need to get this into one formulated cell. I have been struggling for several hours. I would love any advice. I have tried If and, If or, but I can only get the first problem solved, the rest error out.