Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import excel spreadsheet into an excel spreadsheet | Excel Worksheet Functions | |||
In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |