+ Reply to Thread
Results 1 to 4 of 4

Applying 4 conditions to get End of Service benefit ESOB (gratuity )calculation

  1. #1
    Registered User
    Join Date
    06-29-2015
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    24

    Applying 4 conditions to get End of Service benefit ESOB (gratuity )calculation

    Good Day to All

    Attached excel sheet is a format where I am requesting your contribution for getting a formula for EOSB (Gratuity ) calculation.
    I need to get formula on E24 by looking at two cell I20 which can have a values either "RESIGNATION" OR "TERMINATION" and I21 which can be either "LIMITED" OR "UNLIMITED" .
    Depending on these two criteria, the value of gratuity should be results as explain right side of same sheet.
    Kindly assist with your valuable help

    Thanks and respectfully
    Jayaraj
    Last edited by jayarajmarydasan; 05-10-2017 at 01:35 PM. Reason: Previous one was incomplete

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Applying 4 conditions to get End of Service benefit ESOB (gratuity )calculation

    ...don't forget to attach the file...
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    07-12-2018
    Location
    Uae
    MS-Off Ver
    2010
    Posts
    2

    Re: Applying 4 conditions to get End of Service benefit ESOB (gratuity )calculation

    Hi

    Did you get

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,401

    Re: Applying 4 conditions to get End of Service benefit ESOB (gratuity )calculation

    Why don't you start your own thread?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. UAE Gratuity Calculation
    By hjakhan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-15-2024, 09:29 AM
  2. Uae gratuity calculation
    By Vijinesh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-17-2019, 01:25 AM
  3. [SOLVED] Gratuity Calculation
    By fareedexcel in forum Excel General
    Replies: 2
    Last Post: 10-24-2018, 01:48 AM
  4. Replies: 1
    Last Post: 07-16-2015, 06:11 AM
  5. [SOLVED] Years of Service for Benefit Calculation
    By monid78 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2013, 11:20 AM
  6. Gratuity Calculation
    By pnsrinath in forum Excel General
    Replies: 1
    Last Post: 01-09-2013, 12:53 PM
  7. Gratuity calculation
    By st_judeu@yahoo.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-17-2010, 05:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1