Excel Spreadsheet
=INT(C4)*1.75
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Newfie809" wrote in message
...
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
|