Results 1 to 4 of 4

Returning a Certain Result based on a specific data range

Threaded View

  1. #1
    Registered User
    Join Date
    12-06-2007
    Posts
    13

    Question Returning a Certain Result based on a specific data range

    Hi

    I have a problem with a calculation i am trying to do. I have to calculate holiday allocation for staff but i my company also offers length of service bonus days.

    After 5 years you get 1 extra day, after 10 years you get 2, after 15 you get 3 and so on. In my sheet i have a formula based on their start date that tells me their length of service in the following format: 10 years, 2 months.

    I have put an IF Statement in for each of the different milestone criteria but the result is not coming back so i know i am missing something. Is there something wrong with the formula itself or is there a better one that will allow me to put the start and end of the range i want it to look at? For example can i tell it to say if between 5 years and 9 years 11 months put 1, if between 10 years and 14 years 11 months put 2 etc in column H.

    I have attached the sheet to show what i have done so far, any help would be much appreciated!!

    Thanks

    Mark
    Attached Files Attached Files
    Last edited by marktaylor; 11-26-2009 at 07:28 AM. Reason: Now Solved

Thread Information

Users Browsing this Thread

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

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