I have two columns one for pay rate(dollar amount) and one for work comp classification (3 options: carpenter, painter or clerical). I also have a legend that has 5 different rates based on different criteria. The criteria is as follows carpenter >35, carpenter<35, painting>26, painting<26, and Clerical. I'm trying to create a formula that will resource those to columns and put the number associated with the legend above. I was able to do this for one criteria with and if(and formula but was not able to extend it to other options. Any help here would be great. See formula that works below for only one criteria.
=If(AND[Pay Rate(per hour)]@row > 35, [WC Classification]@row = "Carpenter"), $[Pay Rate(per hour)]$20