Multiple conditions using greater than or less than.
in [General]
|
From: Jane Jane on 9 Mar 2010 15:40 I am trying to create a formula to help me with the below scenerio. I need to calculate how many days of PTO time someone would get based on years of service. the years of service cell is less than 2, the employee gets 11 days of pto if the years of service =2 or anything up to 3, the employee gets 16 days of pto if the years of service is =3 or anything up to 4, the employee gets 17 days of pto if the years of service is =4 or anthing up to 5, the employee gets 18 days of pto if the years of service is from 5-19 years, the employee gets 22 days of pto I think you can see the pattern from this partial information. Any guidance would be much appreciated!
From: Mike H on 9 Mar 2010 15:51 Jane. This looks at years service in A1 and calculates PTO whatever that is =LOOKUP(A1,{1,2,3,4,5},{11,16,17,18,22}) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Jane" wrote: > I am trying to create a formula to help me with the below scenerio. > > I need to calculate how many days of PTO time someone would get based on > years of service. > > the years of service cell is less than 2, the employee gets 11 days of pto > if the years of service =2 or anything up to 3, the employee gets 16 days of > pto > if the years of service is =3 or anything up to 4, the employee gets 17 days > of pto > if the years of service is =4 or anthing up to 5, the employee gets 18 days > of pto > if the years of service is from 5-19 years, the employee gets 22 days of pto > > I think you can see the pattern from this partial information. > > Any guidance would be much appreciated! >
|
Pages: 1 Prev: Refresh pivot chart when info in a cell changes Next: Excel shortcut keys |