• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

First Post - Formula Assistance

W

Wendy Bent

New Member
I am attempting to create a formula that will return a set number based on an employee's hire date. For example, after they completed three years of service, they increase in vacation accruals. Here is the formula (in cell O49 on sheets 1 - 13) that I created that I thought worked.

=IF(C12<=1095,8,IF(C12>=1096,10,IF(C12>=2556,12,IF(C12>=4381,14,IF(C12>=6571,16)))))

However, if it meets the first set of criteria, then it doesn't move to the next if statement. Now, I am stuck.

I then changes gears and attempted a VLookup. However, since I am looking for numbers that are most often between a set of numbers, I get an error because the specific number isn't in the table. (in cell Q49 on tabs 1 through 13)

Would anyone be able to help me? I am complete stuck. I uploaded my document.
 

Attachments

well the IF function is working correctly how you have it written. you provide a 'condition' and a IF TRUE & IF FALSE argument... so if you first condition is IF C12<=1095, and that is found to be True, it will display 8. if its not true, then it will look at the IF FALSE argument where you've placed another IF function....

so if someones 'days of service' is less than 1095 do you want something other than "8" to be the result?

from what i see, if i go in your sample file and change c12 to be various numbers, your formula appears to be working...
 
You must log in or register to reply here.
Back
Top