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