OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 176)

Each function has a number of arguments used in the calculations. These arguments

may or may not have their own name. Your task is to enter the arguments needed to

run the function. In some cases, the arguments have predefined choices, and you may

need to refer to the online help or Appendix B (Description of Functions) in this book

to understand them. More often, however, an argument is a value that you enter

manually, or one already entered in a cell or range of cells on the spreadsheet. In

Calc, you can enter values from other cells by typing in their name or range, or—

unlike the case in some spreadsheets—by selecting cells with the mouse. If the values

in the cells change, then the result of the function is automatically updated.

For compatibility, functions and their arguments in Calc have almost identical names

to their counterparts in Microsoft Excel. However, both Excel and Calc have functions

that the other lacks. Occasionally, functions with the same names in Calc and Excel

have different arguments, or slightly different names for the same argument—neither

of which can be imported to the other. However, the majority of functions can be used

in both Calc and Excel without any change.

Understanding the structure of functions

All functions have a similar structure. If you use the right tool for entering a function,

you can escape learning this structure, but it is still worth knowing for

troubleshooting.

To give a typical example, the structure of a function to find cells that match entered

search criteria is:

= DCOUNT (Database;Database field;Search_criteria)

Since a function cannot exist on its own, it must always be part of a formula.

Consequently, even if the function represents the entire formula, there must be an =

sign at the start of the formula. Regardless of where in the formula a function is, the

function will start with its name, such as DCOUNT in the example above. After the

name of the function comes its arguments. All arguments are required, unless

specifically listed as optional.

Arguments are added within the parentheses and are separated by semicolons, with

no space between the arguments and the semicolons.

Note

OOo uses the semicolon as an argument list separator, unlike Excel which

uses a comma. This is a common mistake made by users accustomed to

entering Excel formulas.

Many arguments are a number. A Calc function can take up to thirty numbers as an

argument. That may not sound like much at first. However, when you realize that the

number can be not only a number or a single cell, but also an array or range of cells

that contain several or even hundreds of cells, then the apparent limitation vanishes.

Depending on the nature of the function, arguments may be entered as follows:

"text data" The quotes indicate text or string data is being entered.

9 The number nine is being entered as a number.

"9" The number nine is being entered as text

A1 The address for whatever is in Cell A1 is being entered

176 OpenOffice.org 3.3 Calc Guide

1 2 ... 171 172 173 174 175 176 177 178 179 180 181 ... 433 434

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 176

Comentarios a estos manuales

Relacionado con productos y manuales para Software OpenOffice.org OpenOffice - 3.3