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.