I need help with a formula


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!


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?



Thanks, you’re a star - worked perfectly!