Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert value based on range
Here is what I'm trying to accomplish...I want a formula that will populate
the rate based on the employee's age... So I want it to compare column C to the range in column A and return the rate from column B to Column D. As far as I can tell, there are too many options to use nested IF statements. Can anyone help? A B C D Age Employee EE Age Rate 0-24 $0.05 33 0.08 25-29 $0.06 30-34 $0.08 35-39 $0.09 40-44 $0.10 45-49 $0.15 50-54 $0.23 55-59 $0.44 60-64 $0.68 65-69 $1.27 70+ $2.06 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
Macro to insert a formula based on a range | Excel Discussion (Misc queries) | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions |