I need help with a formula


#1

For our countries provident fund employers and employees each pay 5% of the salary into the fund on a monthly basis, but the 5% is capped at $1500 max. I started out with “{relevant income} *.05” but that messed up for people earning more the $30,000 /month. Plus one employee is 65 and contributions have ceased for him. I’m not at all sure about what the grammar rules for formulas are. I hope someone can help me or point to some good educational resources, youtubes, etc. Thanks!


#2

This should do it for you:

and here it is in action:

You can find out more about formulae in this Airtable page:

I hope this helps?

Julian


#3

Thanks, you’re a star - worked perfectly!