Hi

My last posting I had asked for help and when I used the formula they gave
me, I had said that it did not work. I did send another message to say that
I was wrong and that it did work.

I would like somemore help if anyone can help me with this one.

It's the same spreadsheet and I could use some more input. Thanks
A B C D E F
1. Name Grid Years FTE Amount Allowance
2. John A1_E 10.0 1.0 00.00 00.00
3. Jane A2_E 9.5 .50 00.00 00.00
4. Judy A3_E 9.7 .75 00.00 00.00
5. Bill A3_E 9.7 1.0 00.00 00.00

I have to round down so if I have someone in A3_E and the years are 9.7 it
should be 1.75 at 9 years service.

Can anyone help.

thanks




Newfie