sorry.i want the formula to say how many days an employees leave allowance is
based on their pay point and number of years service. e.g. if employee is on
paypoint 24 and have been here for more than 5 years they would have 25 days
leave.

"Michael" wrote:

I don't understand what you want?
what do you want the formula to say and where?

"jennie999" wrote:

this may be a similar post to one entered recently but i desperately need
some help with a formula. i have 2 variables each with 3 options. For each of
the 9 possible combinations i need a different answer. this is to do with
employee leave and is dependent on their paypoint and length of service.
less than 5 YRS hit 5 years btwn 5+ YEARS@01/04/08
@01/04/07 01/04/07&01/04/08

4 - 21 20 0 25
22 - 28 21 0 25
29 - 40 23 0 26

i have the list of paypoints stored in E column and list of date they hit 5
yrs service in column J.
if anyone could provide me with a formula - i have tried and failed with IF
& AND functions - or let me know if i can do it a different way i would be
really grateful!!
thanks in advance!