Using Formulas and Functions
- Chapter 7 Using Formulas and Functions
This is Chapter 7 of the OpenOffice.org 3 Calc Guide, produced by the OOoAuthors group.
A PDF of this chapter is available from this wiki page.
Formulas
In previous chapters, we have been entering one of two basic types of data into each cell: numbers and text. However, we will not always know what the contents should be. Often the contents of one cell depends on the contents of other cells. To handle this situation, we use a third type of data: the formula. Formulas are equations using numbers and variables to get a result. In a spreadsheet, the variables are cell locations that hold the data needed for the equation to be completed.
Using functions
A function is a pre-defined calculation entered in a cell to help you analyze or manipulate data in a spreadsheet. All you have to do is add the arguments, and the calculation is automatically made for you. Functions help you create the formulas needed to get the results that you are looking for.
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |
