Dear Spaark and other Respected Members,
Can you help me to get the formula to calculate gratuity, the mode of calculation is mentioned in the remarks column. I know I need to apply the "IF" conditions but honestly I have no clue on it. please help.
Regards
Dr. Anjali Kaif
| No | Name | Salary | Basic | HRA | Allow | Total | DOJ | DOR | Yrs of Ser | Gratiuty | Remarks |
| 1 | A | 7,500.00 | 4,500.00 | 1,875.00 | 1,125.00 | 7,500.00 | 1-Nov-99 | 4-Jun-08 | 08 07/12 | 38,687.67 | Basic * monthly pay as years of service is > 5 |
| 2 | B | 2,500.00 | 4,500.00 | 1,875.00 | 1,125.00 | 7,500.00 | 1-May-06 | 4-Jun-08 | 02 01/12 | 2,200.68 | Basic * 7 days monthly pay as years of service is < 3 but >1 |
| 3 | A | 4,500.00 | 4,500.00 | 1,875.00 | 1,125.00 | 7,500.00 | 2-Aug-04 | 4-Jun-08 | 03 10/12 | 12,099.45 | Basic * 21 days monthly pay as years of service is < 5 but >3 |
| 4 | B | 5,000.00 | 4,500.00 | 1,875.00 | 1,125.00 | 7,500.00 | 1-Jan-08 | 4-Jun-08 | 00 05/12 | 0.00 | Basic * 0 as years of service is < 1 |
KERALITES - A moderated eGroup exclusively for Keralites...
To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.
To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.
Homepage: www.keralites.net
To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.
To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.
Homepage: www.keralites.net
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
.
__,_._,___
