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

Chapter 6. Automating Calculations with ... > Doing Higher Math with Functions

Doing Higher Math with Functions

Functions are ready-made formulas you can use to perform a series of operations using two or more values or a range of values. For example, to determine the sum of a series of values in cells A5 to G5, you can enter the function =SUM(A5:G5) rather than =A5+B5+C5+D5+E5+F5+G5. Other functions can perform more complex operations, such as determining the monthly payment on a loan when you supply the values for the principal, interest rate, and number of payment periods.

Every function must have the following three elements:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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