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

Chapter 11. Working with Functions > Function or Formula?

11.1. Function or Formula?

The terms function and formula as they apply to Excel are frequently interchanged. It is confusing to differentiate between the two, but this may clarify things: functions are built-in tools for performing specific calculations, comparisons, and so on. A function in Excel performs a desired task. For example, the SUM function adds numbers together. When you use the SUM function in a cell to sum the values in two cells, such as =SUM(A1,A2), it becomes a formula.

When selecting one of the built-in functions for a formula you don't need to know exactly what calculations are required to determine the factorial of a number -- you can select a function to do the calculation for you.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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