| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return a value that falls within a defined range
=IF(AND(A10,A1<=5),1,IF(AND(A15,A1<=10),0.875,"" ))
Vaya con Dios, Chuck, CABGx3 "Suzieq" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return a value that falls within a defined range
Suzieq wrote: 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. Another solution is to use a vlookup table: 1 1.00 6 .875 11 etc etc. Be sure to set the 4th parameter of the vlookup function as TRUE. |
| Reply |
| 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 | |||
Linear Mode
