I need help with a formula

[Allan_Smith]

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!

[Julian_Kirkness]

This should do it for you:

and here it is in action:

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

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

I hope this helps?

Julian

[Allan_Smith]

Thanks, you’re a star - worked perfectly!