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

Formula Basics

To add two numbers, you could select a cell and type =23+43. To add the contents of two cells, you use their addresses in the formula, as in =B3+B4. (The addresses are referred to as cell references; that is, you're referring to the cells by their addresses.) The cell into which you type the formula displays the result of the calculation as soon as you move to a different cell.

If data in any referenced cell changes, the result instantly changes. This quick recalculation lets you perform what-if analyses. Just change any of the numbers in the referenced cells to see how the changes affect the results.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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