
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 06, 2018 12:26 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 06, 2018 03:18 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 06, 2018 11:18 PM
Thanks, you’re a star - worked perfectly!
