Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to return a single value for a range of numbers
I need a formula to return a value in a column (say column B) for a number in
Column A based on a range: EX: As in grading, A = 90-100, B=80-90, etc. I have a column of data of various salaries. If the salary is between x and x, i need to return a corresponding letter set up by our salary grades. example: here are the values Grade Level A 29,000 - 30,000 Grade Level B 25,000 - 28,999 Grade Level C 23,000 - 24,9000 Column A Column B Salary Grade Level $29,500.00 A $26,500.00 B $25,100.00 B $24,000.00 C I want a formula in column B, that returns the corresponding value from column A in column B. I tried IF statements using and = but I cannot get it to recognize the range. thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
How do I use a range of numbers in an if statement? | Excel Worksheet Functions | |||
How do i set up a range of numbers which prompts at a particular n | Excel Discussion (Misc queries) | |||
return a value based on a range | Excel Worksheet Functions | |||
get a count of numbers whose value falls within a given range | Excel Worksheet Functions |