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!
I need help with a formula
This topic has been closed for replies.
+4This 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
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
Thanks, you’re a star - worked perfectly!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.