Click Okay, and you will see that reference. Select the reference you want to go to, in this case, there's only one. Click the dashed line, and that displays the Go to dialogue box. You can tell your mass pointer is in the correct position when it changes to an upward pointing arrow, upward and to the left. So, with cell D9 selected, if I click Trace Precendents, then, I see the previous cells, which I identified earlier, and I also see that I have an external reference, and that could be another workbook, it can be another worksheet. If you look at the formula bar, you can see that it uses a value from cell B1 on the Acquisition Cost worksheet. In this case, I happen to know that the cost to replace a 10% loss, which is the formula in cell D9, uses a value from another worksheet. If you want to identify precedents or dependents other than the worksheet, or perhaps, in another workbook, then you can do that. You can also trace a cell's dependence, in other words, are there any cells in our worksheet that use the value in cell D3, as input for its formula? Well, with cell D3 still selected, I will click the trace dependents button, and we can see that both the formulas in D6 and D9 use the value from cell D3. Go to the Formulas tab on the ribbon, and then, to display the precedents, that is the input values for a formula, in the cell that you've selected, click the Trace Dependents button, and you can see here that the cell range of B4 through B15, provides the values for the sum of all inquiries. To do that, select the cell that contains the formula you want to analyze, in this case, I already have cell D3 selected. You can identify those cells using tracer arrows. Displaying a cell's precedents indicates which other cells provide the formula's inputs, while displaying its dependents shows which other cells use the selected cell's value as an input. Cells can play one or two roles in a formula, either as a precedent or as a dependent. My sample file is the Tracing workbook, and you can find it in the Chapter Five folder of the exercise files collection. I will show you how to trace precedents and dependents in your formulas in this movie. One of those tools gives you the ability to determine which cells are used in which worksheet formulas. Excel includes a number of terrific tools that you can use to ensure your formulas include the proper values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |