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 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.
Writing Basic Formulas
Using Cell References in Formulas
The advantages of this are that:
- if you later change your data the formula automatically updates to show the new result
- in certain instances, using cell references makes it possible to copy formulas from one location to another in a worksheet
Built-in Formulas: Functions
Spreadsheet programs also contain a number of built-in formulas called functions.
Functions make it easier to carry out:
- commonly performed tasks - such as adding up columns or rows of numbers
- long or complex operations.