| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I compare a result to a range of values?
I have a percentage (26.9%) that I need to compare to a table to see what
amount of bonus my group receives. (ie 0-22.5%=$7200, 22.6%-23.8%=$6600) and so on. So I need to be able to return a bonus value for whenever the percentage falls. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Range of Values Returns One Result | Excel Worksheet Functions | |||
| Compare to a range of values using "from/to" | Excel Discussion (Misc queries) | |||
| Compare alpha and numeric values within a range | Excel Worksheet Functions | |||
| Compare cell = one result | Excel Discussion (Misc queries) | |||
| compare one row to another and sum the result | Excel Discussion (Misc queries) | |||
Threaded Mode
