lundi 18 février 2019

How can I keep the same cell reference in if function, until the if function is true/false?

I have the following function in excel:

INDIRECT(CHAR(COLUMN()+53)&O1+1)

This function has to be the outcome of an if-statement when the statement is true. I don't want the O1 to change to O2, O3, etc.. when I drag the function down, until the statement is true. From there I want the function to change this cell reference in ascending order. So as long as the if statement is false, the reference needs to be O1.

I know that absolute referencing can be used to keep the same cell-reference ($O$1), but then the cell reference doesn't change when the statement is true either.

Does anyone know how I can solve this?

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire