Forum Discussion
Solved
Please Help!! How to Automatically update other fomulas on other cell when changing 1 formula.
Hi, Can some one please help me with this. I have many big tables with thousands of columns which are placed vertically. Example(smaller version attached): At the end of each column, there...
Instead of hard coding the criteria in the formula, why not input the criteria in a cell, say F1, and then your formula will become...
=IF(B5>$F$1,"P","F")
In the above formula $F$1 is the cell that contains the criteria and the above formula will work like your existing formula if you input 3 in cell F1.
Change all other formulas in the same way. Then you only need to change the criteria in the criteria cell F1 and all the formulas will be updated automatically.
Thank you very much for your help
You're welcome tonythien! Glad it worked as desired.