Looking for help writing formula for pay earned based on variable

[Ryan_Anderson1]

I’m looking for help writing a formula to show what pay a staff member has earned based on a variable.

I have hours worked (at 30 per hour for one role, and 25 for a different role), and trainings complete at 50 per session.

How do I write a formula that looks at the “role assigned select field” and calculates based on the correct rate of pay?

Thanks,

[JonathanBowen · Accepted solution]

Hi @Ryan_Anderson1 - you can do something like this:

IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25})

and then to include the trainings you can extend this with:

IF({Role Field} = 'Role 1', {Hours field} * 30, {Hours field * 25}) + {trainings complete field} * 50

For 2 roles, an IF statement is fine. If you end up with more than this, you can move to SWITCH statement, which is often easier than multiple nested IFs

[Ryan_Anderson1]

Thank you! I’ll start there and see if I have any issues, thank you!

[JonathanBowen]

JonathanBowen:

{Hours field * 25}

This isn’t correct - should be:

{Hours field} * 25