Troubleshooting Formula Errors
When you enter a formula incorrectly into a cell, Excel displays an error message. Formulas can be entered incorrectly for a variety of reasons. Typing mistakes are usually the biggest cause of formula errors. If you mistype an operator or function name, Excel returns an error instead of the desired result.
The next biggest reason that formulas return error values is improper syntax. Syntax is everything when you're entering formulas; your formula must conform exactly to Excel's format. For example, if your formula contains a blank space, the formula errors out.
Excel often provides information about the errors it finds in formulas. With Excel's help, you can usually fix the problem. If the formula looks okay but ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
