mercredi 3 novembre 2021

How do I run an Excel formula in one cell (have it produce a value) ONLY if another cell's formula produces a value?

I want to run this Excel formula:

=IFERROR(INDEX(Y163:AA163,MATCH(TRUE,Y163:AA163<>"",0)),"")

But ONLY if the formula in cell B163 produces a result/value.

I've tried different formulas but cell X163 still produces a value even though B163's formula has not produced a value.

Example formulas I've tried:

=IFERROR(IF(LEN(B163)<>"",(INDEX(Y163:AA163,MATCH(TRUE,Y163:AA163<>"",0)),""),"")
=IFERROR(IF(B163<>0,(INDEX(Y163:AA163,MATCH(TRUE,Y163:AA163<>"",0)),""),"")

In other words, I want a formula in X163 that states that if B163's formula results in a value or is not equal to 0, then run the formula beginning with "INDEX." On top of this, put this all in an IFERROR statement, because that's what I do with all my formulas. So there are a lot of nested formulas/statements.

How can I get this new condition to override other conditions?

Aucun commentaire:

Enregistrer un commentaire