No Tags Found!

yahyaadari
1

Hi,
Please i need ur help, i wanted to automate seniority allowance computation (with if condition) as per attachment sheet, but i am not clear about the formula
criteria are as below
seniority is 2% per year of service with a ceiling of 52%
* For local staff : - senirity comprised b/w 1 and 25 years =2%xBasic Salaryx Service Year
- seniority >= 26 Years : Basic Salary x 52%
For Expat staff, seniory allowance is not required , i.e 0
Thannks in advance, ur help is very much needed

From Djibouti
Attached Files (Download Requires Membership)
File Type: xls Sheet.xls (26.5 KB, 83 views)

yahyaadari
1

Hi,
To be more pricise and accurate, see the same attachment filled with if condition.
cells corresponding expat display "FALSE" whereas it should display 0 as expats are not entitled to seniority allowance.
Many thanks

From Djibouti
yahyaadari
1

the attachment was omiited. here it goes. Thanks
From Djibouti
Attached Files (Download Requires Membership)
File Type: xls Sheet.xls (26.5 KB, 41 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.