Formulas and Functions

Formulas and Functions. What’s the difference?

There are many definitions of Formulas and Functions available on the web. The most succinct and understandable comes from the About.com Guide, the definition of Formula:

Formulas in spreadsheet programs such as Excel are used to perform calculations. Formulas can range from basic mathematical operations – such as addition and subtraction – to complex engineering and statistical calculations. In programs such as Excel, Open Office Calc, and Google Docs Spreadsheets, formulas begin with an equal ( = ) sign and, for the most part, they are entered into to the worksheet cell(s) where we want the results or answer to appear.

And the definition of Function from About.com:

A function is a preset formula in Excel. Like formulas, functions begin with the equal sign ( = ) followed by the function’s name and its arguments. The function name tells Excel what calculation to perform. The arguments are contained inside round brackets. For example, the most used function in Excel is the SUM function, which is used to add together the data in selected cells. The SUM function is written as –

= SUM ( D1 : D6 )Here the function adds the contents of cell range D1 to D6 and displays the answer in cell D7.

This section is dedicated to articles, examples, tutorials, and references that specifically address Formulas and Functions in Excel.