trace precedents and dependents
1 Answer(s)
Bertrand
Precedents and Dependents are as follows:
When you have two cells in Excel
A1 has a value of 50
B1 has a formula of =A1*6.1
So A1 is the precedent and B1 is the Dependent because the value of B1 depends on the value of A1
But if A1 is already has a formula like =G1 + 10
Then A1 in this case is dependent and precedent in the same time
Jan 09 2014 12:47 PM
When you have two cells in Excel
A1 has a value of 50
B1 has a formula of =A1*6.1
So A1 is the precedent and B1 is the Dependent because the value of B1 depends on the value of A1
But if A1 is already has a formula like =G1 + 10
Then A1 in this case is dependent and precedent in the same time