mardi 9 mai 2017

INDIRECT function next to IF function

I'm not sure how this works, but is there any chance someone can help me?

I need the indirect function to work with another formula i have since it references a cell that is constantly moving (new rows are being added above it by an outlook VBA i have which means the formula reference changes) but i always need this formula to reference A2.

Here is the function I am using: =IF(A2="online","ON",IF(A2="offline","OFF","ON"))

Where does the Indirect go? Can it even go in here?

:)

Aucun commentaire:

Enregistrer un commentaire