| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return a value that falls within a defined range
I am sure this is simple but what formula can I use to return a value within
a range of numbers. Here is specifically what I am trying to do: If a cell contains the number 1 through 5 the value returned is 1.00, if the same cell contains the value 6 through 10 the value returned is .875 etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif to return a blank if sum range is blank | Excel Worksheet Functions | |||
| check whether a date falls in a range | Excel Discussion (Misc queries) | |||
| return min. of range except 0 | Excel Discussion (Misc queries) | |||
| calculating return in a range | Excel Worksheet Functions | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
Threaded Mode
