• About the site - Computer News Deals.com
  • Computer News Deals.com is a web portal with very unique concept of news blended with other important aspects of computer and internet technology.
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
Related News
TMC Names ContactWorld a 2016 Communications Solutions Product of the Year Award Winner
How to rearrange the quick-actions tiles in the Windows 10 Anniversary Update
How to get Android Nougat on your Nexus device right now
Deus Ex: Mankind Divided review: Human Evolution