Sorry, but my I'm still not sure how to make my formula evaluate a full range
of values. For example, the cell I need to populate will have values based
on what is calculated in another cell as follows:
If value in cell A1 is 1.0 and 0 in new cell
.900 - .999 1 in new cell
.800 - .899 2 in new cell
all the way down to <.100 which should put a 10 in the new cell.

Thanks again for all the help! It is definitely a learning experience for
me.

Ken
--
akkrug