Forum Discussion
Excel Formula References Changing When I Insert a Row
Hello, I have multiple excel workbooks, where if I insert a row, it stuffs up my formula references (i.e. formulas start referencing the wrong cells) even though I haven't changed the formula. Th...
I am not using a =SUMPRODUCT formula, even simple formulas like =A28 are stuffing up. It is as though Excel has corrupted because it is happening to a colleague too. Harun24HR
kinda have the same problem my formula is
=SI(C29="";"";RECHERCHEV(C29;Produit;2;FAUX))
and if i insert a row or move the data on c29 the formula change itself to
=SI(#REF!="";"";RECHERCHEV(#REF!;Produit;2;FAUX))
could it be the same as you ??? no clue what to do
=SI(C29="";"";RECHERCHEV(C29;Produit;2;FAUX))
and if i insert a row or move the data on c29 the formula change itself to
=SI(#REF!="";"";RECHERCHEV(#REF!;Produit;2;FAUX))
could it be the same as you ??? no clue what to do
