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