| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Obtain rate for work center, depending on year
On a worksheet, we have 72 work centers, and charge rates for each
year and each center in a table; going out 12 years. W/C 2008 2009 2010 etc 1 15.00 16.98 18.10 2 23.98 24.25 26.98 3 11.00 13.85 15.65 etc. Would like to obtain the rate for each workcenter on another sheet for the year thats entered into cell A1 in the worksheet. A bunch of IF statements. . .=IF(YEAR(D14)=2008,TRUE,FALSE) could be really clumsy as a place to start, as there are 12 years to chose from, making the formulas particularly messy. Thoughts? Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obtain a Year to Date result without all cells of data being fille | Excel Worksheet Functions | |||
| unmerge cells when the merge and center button doesn't work | Excel Worksheet Functions | |||
| Multiply by a rate depending on the value | Excel Worksheet Functions | |||
| Display number of day of month depending on the year | Excel Discussion (Misc queries) | |||
| Work out Credit card Payments to obtain an end date | Excel Discussion (Misc queries) | |||
Threaded Mode
