Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return a value based on multiple possible conditions?
I am trying to assign a specific value to a cell based on multiple
choices. For example, cell A1 needs to be "A", "B", "C" or "D" (pay grades) This value is based on what is contained in cell B1. If the value in B1 is between 12.00 and 20.00, A1 needs to = "A" If the value in B1 is between 20.01 and 28.00, A1 needs to = "B" If the value in B1 is between 28.01 and 39.00, A1 needs to = "C" If the value in B1 is between 39.01 and 52.00, A1 needs to = "D" I've tried a number of different formulas, but can't make it work with =IF alone, since it only returns one of two values based on a single condition. How do I make the formula return one of four values based on four different conditions? I have to have this on another desk by tomorrow morning! Any help anybody can give would be much appreciated, and then some! Thanks in advance, Mike Simard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple conditions and multiple return values | Excel Worksheet Functions | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
COUNT using multiple conditions | Excel Discussion (Misc queries) | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions |