Anila has attended:
Excel Intermediate course
Excel intermediate-formulas
if there is a large document and there is an error with a formula, how do you know where the problem is and which formula is the wrong one...
RE: excel intermediate-formulas
Hi Anila
Hope you are well, as for your question about tracing errors, you may remember from the course yesterday, when an error comes up with a formula one of two things happen either you will get an error message, or your will see something the word value in the cell when you press enter
How to find out where the error is, is by getting the formula auditing toolbar, and when you have this click the trace errors button
Hope this helps you if you need anymore help either post another question on the forum or you could email me on mark@stl-training.co.uk
Mark East