Any ideas

Jim Mika

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

Paul Newcome

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, "?")))

Paul Newcome

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?

Jim Mika

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.

Paul Newcome

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, "?")))

Jim Mika

Perfect.....thank you

Paul Newcome

Happy to help. 👍️