This is a "self-contained" formula, where no outside datalist is necessary,
since all values are included in the formula itself.

Enter this in AV1, and copy down as needed:

=IF(F1<=100,"inc",LOOKUP(AC1,{0,0.1,0.2,0.275,0.35 ,0.425,0.5,0.575,0.65,0.75;1,2,3,4,5,6,7,8,9,10}))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"bob" wrote in message
...
In column AC I have values that range from .000 to 1.000.
In column F I have values that range from 1 to 2,000.

In column AV, I want to place a value from 1 to 10, depending on the
corresponding value in column AC. The only exception is that if column F
<=100, the correspinding value in AV should be "Inc." (for Incomplete)

The values in AC should correspond to the values in AV, as follows:

..000 to .099 = 1
..100 to .199 = 2
..200 to .274 = 3
..275 to .349 = 4
..350 to .424 = 5
..425 to .499 = 6
..500 to .574 = 7
..575 to .649 = 8
..650 to .749 = 9
..750 to 1.000 = 10

thanks,
Bob