Total Gratuity days to pay


T

Tia

Dear All,

I am trying to calculate the end of service gratuity.
The Rules are as follows:
Employee:
If the employee resigns under total years of service from 1 till 3
years his gratuity pay will be 7 days for each year
For each working day
If the employee resigns under total years of service from 3 till
infinity years his gratuity pay will be 21 days for each year for each
working day

If the employers terminate the employee under total years of service
from 1 till infinity years his gratuity pay will be 21 days for each
year for each working day+ Ticket.

What I am looking for is a formula for F1 that allows me to get total
gratuity days to pay

A1: Employee Name
B1: Total Package per day
C1: Starting Date
D1: Total Years so far
E1: Termination/ Resignation
F1: Total Gratuity days to be paid


Thank you in advance
 
Ad

Advertisements

B

Bernard Liengme

Here is a start
=IF(E1="T",21,IF(D1<3,7,21))*D1
This assumes E1 can only be T or R

I am not sure what "ticket" means so you many need to modify this to
=IF(E1="T",21 + something, IF(D1<3,7,21))*D1

Also I am confused by the phrase "each working day" in the specification
"gratuity pay will be 7 days for each year for each working day". You may
need to adjust for this.
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top