| Home : August 24 2016 Computer News : Excel formula tips: How to troubleshoot by tracing dependents and precedents |
|
Excel formula tips: How to troubleshoot by tracing dependents and precedents |
August 24, 2016
When your spreadsheet has formulas piled on top of formulas, tracking and repairing errors would be agony if it weren't for Excel's Precedents and Dependents: cells that are referred to by a formula in another cell, and cells that contain formulas that refer to other cells, respectively. The next time you need to find out how the formula in C100 affects the formula in E175, which impacts the results in cell G225, try this technique. To view all the relationships between the cells in your spreadsheets, position your cursor on a cell with a formula that affects other cells (a Precedent) or choose a cell that contains information based on the results of other cells (a Dependent).To read this article in full or to leave a comment, please click here
Link: http://www.pcworld.com/article/3077536/software/excel-formula-tips-how-to-troubleshoot-by-tracing-dependents-and-precedents.html#tk.rss_howto
|
|
|
|
|