• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 44. Letting Excel Do the Math > Troubleshooting Formula Errors

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint