# A Formula for different hourly rates depending on the option selected?

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:
ROUND(MULTIPLY(({Time CW}/3600),15),1)

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”:
IF(Type=SEO)
ROUND(MULTIPLY(({Time CW}/3600),20),1)

IF(Type=Social Media)
ROUND(MULTIPLY(({Time CW}/3600),15),1)

IF(Type=Graphic Design)
ROUND(MULTIPLY(({Time CW}/3600),15),1)

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.

This could be done many ways. Here’s one:

``````ROUND( MULTIPLY(({Time CW}/3600), SWITCH({Type}, "SEO", 20, "Social Media", 15, "Graphic Design", 15, 9999)), 1)
``````

Note: the 9999 is the rate that would be used if the Type is not found. This could be 0, 20, or whatever you want.

1 Like

That worked perfectly! Thanks so much!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.