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

Using the Calc Detective

When you create formulas and functions for your spreadsheets it is essential that you reference the correct cells in them. No matter how good a formula or how well chosen a function, you won't get the correct answer if the formula is not looking at the appropriate values on the Calc sheet.

A tool that will help you troubleshoot your formulas (and your functions) is the Detective. The Detective allows you to view two entities related to formulas. You can have Calc display the cells that are referenced by a particular formula. These cells containing data are called precedents. Calc can also show you the cells (those containing formulas) that rely on a cell for a particular value. Cells containing formulas or functions are referred to as dependents, meaning they need to be supplied data from other cells on the sheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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