Here’s a screenshot of the board, with circles around the column titles that will be used in the formula.
The goal is:
When an employee selects a different option from the “Type” column, the rate of pay will change.
SEO = $20 per hour
Social Media = $15 per hour
Graphic Design = $15 per hour
The formula I have so far that works for only one hourly rate of $15:
What I need help with is making a formula that gives different rates, $15 vs $20, depending on if I choose “SEO”, “Social Media”, or “Graphic Design”:
The goal is for the formula to have 2 different rates, and only one of them will activate at a time depending on the Type chosen.