Forum Discussion
Please Help!! How to Automatically update other fomulas on other cell when changing 1 formula.
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.
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.
You're welcome tonythien! Glad it worked as desired.