excel course tate modern - Charts

Hi Katie

Thank you for your question.

In Office 2002/XP and 2003 there is a formula error marker (green triangle) that comes up in the corner of the cell with an error, or suspected error.

This can be quite useful for troubleshooting formula errors. Click on the cell displaying the green triangle and a smart tag with an exclamation mark symbol on it will appear. Holding your mouse over this will reveal a dropdown arrow which you can click on to choose from various options. In particular, Help on this error, Show Calcuation Steps and the Show Formula Auditing toolbar options are useful.

Amanda