Hi,
Please, I need your help. I wanted to automate seniority allowance computation (with an if condition) as per the attached sheet, but I am not clear about the formula. The criteria are as below: seniority is 2% per year of service with a ceiling of 52%.
For local staff:
- Seniority comprised between 1 and 25 years = 2% x Basic Salary x Service Year
- Seniority greater than or equal to 26 years: Basic Salary x 52%
For Expat staff, seniority allowance is not required, i.e., 0.
Thanks in advance, your help is very much needed.
From Djibouti
Acknowledge(0)
Amend(0)
1Please, I need your help. I wanted to automate seniority allowance computation (with an if condition) as per the attached sheet, but I am not clear about the formula. The criteria are as below: seniority is 2% per year of service with a ceiling of 52%.
For local staff:
- Seniority comprised between 1 and 25 years = 2% x Basic Salary x Service Year
- Seniority greater than or equal to 26 years: Basic Salary x 52%
For Expat staff, seniority allowance is not required, i.e., 0.
Thanks in advance, your help is very much needed.
From Djibouti
Acknowledge(0)Amend(0)
Hi,
To be more precise and accurate, please refer to the attachment filled with the if condition. The cells corresponding to expatriates display "FALSE" whereas they should display 0 as expatriates are not entitled to seniority allowance.
Many thanks
From Djibouti
Acknowledge(0)Amend(0)
To be more precise and accurate, please refer to the attachment filled with the if condition. The cells corresponding to expatriates display "FALSE" whereas they should display 0 as expatriates are not entitled to seniority allowance.
Many thanks
From Djibouti
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
SALARY SHEET CALCULATION.xls