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

Chapter 1. Understanding Excel Worksheet... > Understanding Formulas and Functions

Understanding Formulas and Functions

The major difference between a checkbook register and an Excel worksheet is that a worksheet can calculate the new balance for you and perform countless other mathematical calculations through the use of formulas and functions. Excel uses formulas to perform addition, subtraction, multiplication, and division on the entries in a worksheet to determine totals, grand totals, percentages, and other practical results. Figure 1.9 shows a sample formula in action. This simple formula totals the values in cells B4 to E4.

Figure 1.9. Formulas automate calculations in a worksheet.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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