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:

Column AC has 1001 values in it... column F has 2000 values in it... for any
given row in AC, where is the <=100 condition in F (what row) that control
whether the row in AV that corresponds to the given row gets a "Inc." or
not?

Rick