Wed 2 May 2007, 12:54Delegate Rebecca said...
Rebecca has attended:
Excel Intermediate course
Formula Errors
When i have used a formula it comes up with an error and it is somewhere in the table. How can i find where the error is?
Wed 2 May 2007, 15:37Trainer Amanda said...
RE: Formula Errors
Hi Rebecca
Thank you for your question.
You can click on the cell that contains the error, then go to Tools - Formula Auditing - Trace Error.
There is also a Formula Auditing toolbar that you can switch on, and there is a Trace Error button on this toolbar (button with the !)
I hope this helps.
Amanda
