| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if cell falls within range of number (i.e. 2500 to 4999)
I want to detetermine is a cell falls within a pre-estabished set up ranges.
Cell A1 = 4800 Such as if quantity is 2500-4999 it should return 1.5% if quantity is 5000-9999 it should return 1.2% So this correct answer should return 1.5% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNT IF A VALUE FALLS WITHIN A RANGE IN A SINGLE CELL | Excel Discussion (Misc queries) | |||
| displaying text in a cell if a another cell falls in a range | Excel Worksheet Functions | |||
| IF CELL VALUE FALLS WITHIN A RANGE OF VALUES | Excel Worksheet Functions | |||
| update cell only if now() falls in a given date range | Excel Worksheet Functions | |||
| Formula to determine whether number falls within range?? | Excel Worksheet Functions | |||
Threaded Mode
