Excel
formulas and functions
Formulas and functions are the bread and butter of Excel.
They drive almost everything interesting and useful you will ever do in a
spreadsheet. This article introduces the basic concepts you need to know to be
proficient with formulas in Excel. More examples here.
What is a formula?
A formula in Excel is an expression that returns a specific
result.
What is a function?
Working in Excel, you will hear the words
"formula" and "function" used frequently, sometimes
interchangeably. They are closely related, but not exactly the same.
Technically, a formula is any expression that begins with an equals sign 
).
A function, on the other hand, is a formula with a special
name and purpose. In most cases, functions have names that reflect their
intended use. For example, you probably know the SUM function already, which
returns the sum of given references.
No comments:
Post a Comment