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.
|