Precedents, Dependants?

  • Thread starter Thread starter JJSCOTT2
  • Start date Start date
J

JJSCOTT2

What are precedents and dependants in Excel? What can I use them for?
 
If you have a formaula in Cell A6 that is =SUM(A1:A5), then A6 is the Dependent and A1:A5 are the Precedents
Dependent=the cell or cells that contain formulas that reference other cells
Precedent=the cell or cells that contain numbers, text, or formulas required for the Dependent to reach an answer

If you are asking about the Auditing Toolbar, you can use these to look for the source info for formulas
You can also find out what formulas a given cell contributes to

This can be useful on complex workbooks, if you need to map out where an answer is coming from (or where data is going). It can also be important if a formula results in an error

tj
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trace dependants or Precedents on a protected sheet 1
tracing precedent by double clicking cell 3
turning OFF track changes, undo and trace precedents/dependents 6
trace all dependents 1
Trim out last seven characters from a string... 2
Trace dependants/precedents from another worksheet 7
Precedents & Dependents 3
tracing precedents and dependents 3

Back
Top