Really need help trying to find a formula chain where I am able to use a table of billing rates and depending on two inputs ("A or B" and "1 or 2" for a total of 4 unique rates) the formula will spit out the appropriate rate.
So for example...
Rate 1 is $100 and would be applied if A is true and 1 is true
Rate 2 is $200 and would be applied if B is true and 1 is true
Rate 3 is $300 and would be applied if A is true and 2 is true
Rate 4 is $400 and would be applied if B is true and 2 is true
I need a formula that if cell A1 says "A" and B1 says "2"...then the rate "$300" would populate in cell C1.
I tried XOR but that just spits out TRUE/FALSE and not what is contained in a cell.