Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

# Looking for help writing formula for pay earned based on variable

Topic Labels: Formulas
Solved
331 3
cancel
Showing results for
Did you mean:
4 - Data Explorer

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,

1 Solution

Accepted Solutions
13 - Mars

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

3 Replies 3
13 - Mars

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

4 - Data Explorer

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

This isn’t correct - should be:

`{Hours field} * 25`