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

Troubleshooting

If you build formulas by using the Paste Function dialog box and the Formula Palette, you'll have far fewer problems with your formulas. But when you get more comfortable with functions and start writing formulas by typing them yourself, here are some tips to help you avoid or fix problems.

  • Be sure your parentheses are paired and balanced.

  • Use the appropriate type of data in each function argument.

  • Be sure all required arguments in the function have been filled in, and if you still don't get the results you expect, you may need to fill in optional arguments.

  • Don't nest more than seven levels deep in any function.

  • Make sure that any external references (to other worksheets or workbooks) are spelled correctly and in the correct syntax.

  • Don't type punctuation such as dollar signs or commas in argument values—use plain numbers. (If you type a percent symbol or a caret symbol, Excel recognizes it as an arithmetic operator and uses it in the calculation.)

  • See Table 10.3 in Chapter 10 for help with specific formula errors.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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