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.