Any ideas
Hi Guys,
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
Best Answer

Ok. Try this one...
=IF([WC Classification]@row = "Carpenter", IF([Pay Rate(per hour)]@row > 35, $[Pay Rate(per hour)]$20, $[Pay Rate(per hour)]$21), IF([WC Classification]@row = "Painter", IF([Pay Rate(per hour)]@row > 26, $[Pay Rate(per hour)]$22, $[Pay Rate(per hour)]$23), IF([WC Classification]@row = "Clerical", $[Pay Rate(per hour)]$24, "?")))
Answers

Are you able to provide some screenshots of what you are working with along with some manually entered mock data to show what you are wanting to accomplish?

Hi Paul
Please see attached screen shot. I hoping to create formula that will fill the work comp % column for legend above. Let me know if you need any more info.

Ok. Try this one...
=IF([WC Classification]@row = "Carpenter", IF([Pay Rate(per hour)]@row > 35, $[Pay Rate(per hour)]$20, $[Pay Rate(per hour)]$21), IF([WC Classification]@row = "Painter", IF([Pay Rate(per hour)]@row > 26, $[Pay Rate(per hour)]$22, $[Pay Rate(per hour)]$23), IF([WC Classification]@row = "Clerical", $[Pay Rate(per hour)]$24, "?")))

Perfect.....thank you
