Hello,
This is more complicated than it sounds. I need to do an If function to get a
cell reference as a result... Let me give you my situation....

I have an if function that should go like this...

Pretend I am typing this function into cell B1:

"If cell C1 is less than or equal to zero, then reference cell A1, if not
then add 1 to that to reference cell A2 instead."

That way cell B1 will either be referencing cell A1 or A2. But I need this to
be
in such a way that I can copy this function down hundreds of cells in the B
column so that it will always continue to reference down the line to A3 then
A4,
then A5... etc.... but it will only change when the cell in C column is
positive.

Can anyone help? Thanks.