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

ms excel training london - excel auditing

Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training london - Excel auditing

ms excel training london - Excel auditing

ResolvedVersion Standard

Marilyn has attended:
Excel Intermediate course

Excel auditing

how do i trace formula errors?

RE: Excel auditing

Hi Marilyn

In the recent versions of Excel, you will notice a green tag appears in the top left of your cells, if there is an error.

A SmartTag with a yellow exclaimation mark wil appear new to the formula. By click in on this you can track the error in the formula.

Alternatively you can click VIEW > TOOLBARS and then choose Formula Auditing. There are buttons that allow you to trace the error, track predecessors and dependant cells on that toolbar.

Regards

Richard

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.