"jennie999" wrote in message
...
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.

I understand that part but what is a pay point and what does:
4 - 21 20 0 25
22 - 28 21 0 25
29 - 40 23 0 26
have to do with it?


--
Regards,


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"jennie999" wrote in message
...
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!