Posts by behemoth87

    Hello,


    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.


    Thanks!