Creating Formulas—Working with Functions
Ever wonder what the difference is between a function and a formula? It might appear that Excel uses the terms interchangeably, but it really doesn’t. A function is an action that you want to perform. A formula is the entire expression you create, including the function and the related arguments that you supply.
For example, SUM is a function, =SUM(A1:A25) is a formula.
This section looks at Excel functions in general, from accessing the function you need to referencing data, nesting functions, or auditing formulas.
If There’s Logic to It, Excel Functions Can Do It
There’s very little that Excel can’t do when it comes to working with data. More than 300 built-in functions are available from the Formulas tab, ...
Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
