Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Formulas and Functions"
| Line 8: | Line 8: | ||
<!-- A PDF of this chapter is available from [http://documentation.openoffice.org/manuals/userguide3/ Documentation] at OpenOffice.org. --> | <!-- A PDF of this chapter is available from [http://documentation.openoffice.org/manuals/userguide3/ Documentation] at OpenOffice.org. --> | ||
| + | ==Formulas== | ||
| + | |||
| + | Up to now, we have been entering one of two basic types of data into each cell that we have been using, Numbers and Text. However, it is not always the case that we will know what the contents should be. Often what should be there is dependent on the contents of other cells. This is handled by a third type of data known as 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. This helps to facilitate the creation of 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 18:09, 14 September 2009
- Chapter 7 Using Formulas and Functions
This is Chapter 7 of the OpenOffice.org 3 Calc Guide, produced by the OOoAuthors group.
Formulas
Up to now, we have been entering one of two basic types of data into each cell that we have been using, Numbers and Text. However, it is not always the case that we will know what the contents should be. Often what should be there is dependent on the contents of other cells. This is handled by a third type of data known as 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. This helps to facilitate the creation of 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). |
