Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Formulas and Functions"
(Editorial changes) |
|||
| Line 10: | Line 10: | ||
==Formulas== | ==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== | ==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. | + | 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. |
{{CCBY}} | {{CCBY}} | ||
[[Category: Calc Guide (Documentation)]] | [[Category: Calc Guide (Documentation)]] | ||
Revision as of 06:11, 3 November 2009
- Chapter 7 Using Formulas and Functions
This is Chapter 7 of the OpenOffice.org 3 Calc Guide, produced by the OOoAuthors group.
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). |
