Click Evaluate.ġ+0.2 will be evaluated as 1.2. 1+0.2 is underlined showing it as the next step. The expression with an underline will always be executed next. By clicking the Evaluate button several times, the formula gets evaluated step-wise. In the Evaluate Formula dialog box, the formula is displayed in the box under Evaluation. Click Evaluate Formula in the Formula Auditing group.To find how a complex formula in a cell works step by step, you can use Evaluate Formula command.Ĭonsider the formula NPV (Middle Year) in the cell C14. The worksheet containing that precedent appears. The reference appears in the Reference box.Click a reference of one of the precedents.A Go TO dialog box appears, showing the precedents.Īs you observe, there are four precedents, on four different worksheets. The worksheet icon indicates that the precedents are in a different worksheet.ĭouble-click on the arrow. A worksheet icon appears at the end of the arrow. The Formulas in the worksheet will appear, so that you will know which cells contain formulas and what the formulas are.Ĭlick Trace Precedents. The worksheet below contains the summary of sales by the salespersons in the regions East, North, South, and West.Ĭlick Show Formulas in the Formula Auditing group. All the cells under Pass Category in Exam Results table will be mapped as the dependents. Repeat for all the cells under Pass Category in Exam Results table.Ĭlick in a cell under Pass Category in Student Grades table.Ĭlick Trace Dependents.The cell to its left (Marks) and the range E4:F8 will be mapped as the precedents. Click in a cell under Pass Category in Exam Results table. ![]() Now, consider a worksheet with several formulae. You have understood the concept of Precedents and Dependents. Click Trace Dependents in the Formula Auditing group.Click in the cell B6 is not referenced by any formula or click in any empty cell. ![]() Otherwise, you will get an error message. Note − For tracing dependents of a cell, the cell should be referenced by a formula in another cell. All the arrows in the worksheet will disappear.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |