formula

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula

Formula

resolvedResolved · Low Priority · Version 2007

Gene has attended:
Excel Intermediate course
Excel Advanced course

Formula

what is the advantage of formula trace error?

Edited on Fri 4 Apr 2008, 06:59

RE: Formula

Hi Gene, thank you for your post, I hope you enjoyed your course, welcome to the forum.
In answer to your question: If a formula displays an error value, such as #DIV/0!, the Trace Error command or button can be used to locate all cells that provide data to the formula, this will quickly allow you to find the problem/s in your worksheet, Auditing is particularly useful when linking worksheet data to other workbooks.
To use Error Tracking follow these steps;
Select the cell that contains the error
Click on the Trace Error button on the Auditing Toolbar (Tools>Auditing>Trace Error)
Red arrows will point from the cells that cause the error to the cell that contains the error. Blue arrows point to the precedents of the cell that causes the error.
Note: to quickly select the cell at the other end of an arrow, double click on the arrow.
I hope that helps, regards Pete


 

Excel tip:

Create Equations in Excel 2010

Here's how to create basic mathematical
equations in your Excel 2010 worksheet.

1) On the Ribbon, click the Insert tab
2) In the Symbols group, click the arrow next to Equation
3) Select from the equations and the equation will be inserted in a text box

Or you can create your own equation:

1) Insert and select the text box
2) On the Ribbon, click the Insert tab
3) In the Symbols group, click Equation
4) The Equation Tools Design Ribbon will now be displayed

View all Excel hints and tips


Server loaded in 0.08 secs.