This is what I need to do:
I'm using an "IF" function and I need to have the formula operate on a given row by changing one value in a different cell; for example.

Formula =IF(IK7<1," ",B17)
I would like to enter the number "7" in cell "A2" and have the formula read the "7" (in "K7") from cell "A2"

So if I entered 10 in cell "A2" the formula would then read:
=IF(k10<1," ",B17)

Any ideas?

--mark