Hello,
I have a formula in cell AG12= IF($D12=FALSE,AVERAGE(S12,E12),CB12) and this formula was dragged across from cell AG12 to AS12.
This spreadsheet is like a template and people may delete the formula and enter their own numbers if necessary. So I wanted to know if it is possible when cell B4 changed its value those range above can have their formulas back like it used to be before somebody deleted the formulas.
I really appreciate any help. THanks
Bookmarks