Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to contruct formula
I have a spreadsheet with employee names and years of service
Jane 4.65 Joe 2.50 Jill .85 I have data that indicates years and days 1 15 2 16 3 17 I need some form of formula that will allow me to search the grid and place the correct number of days off by the number of years service |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |