OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 245)

Chapter 4: Spreadsheets in Calc

Using Built-in Functions

Calc has many built-in functions, one of which convert Euros to another currency, such as the

US dollar. The following provides an example of using functions to achieve a goal.

Note: A list of functions is available from Help > Contents > Index > Search term > function list; Calc.

1. Enter a formula (e.g. =4+5 or =A3*A4/100) in a cell.

2. Press the “Enter” key.

3. The result of the calculation appears in the cell.

However, functions can also be entered in a formula. An example could be =SIN(1), which

will give a result of sine of one (rounded to two decimal places).

1. Calc has several other functions, too, and additional functions can be added using

StarBasic or AddIns. Help has a section outlining how to do this. In most cases

though, the standard functions provided in the program are sufficient for most

requirements. The function with the Syntax CONVERT(arguments) is shown here as

an example that will convert a sum of 100 German Marks into Euros by entering the

following formula in a cell:

=CONVERT( 100;"DEM";"EUR")

The result will be the number of Euros per 100 German Marks. The value for conversion is

always stated first within the parentheses. It can be entered directly, as shown, or by

reference. If the amount is, for example, in cell D2, enter D2 in the formula as the first part of

the function. The remaining parameters of the function name the unit of the amount and the

unit into which it is to be converted. All three parts of the function are separated from each

other by semicolons.

Thus, using the formula =CONVERT(50;"EUR";"DEM"), displays the number of German Mark

that is the equivalent of 50 Euros. To try this, proceed as follows:

In an new spreadsheet, enter in column D, from D2 to D20 a number of USD sums

1. Designate column E from E2 to E20 as the cells in which the same sums in Euros must

appear.

2. Click in cell E2.

3. Enter =CONVERT(

4. Click in cell D2. D2 is now defined as the first part of the function. The cursor remains at

D2 in the formula.

5. Enter "DEM";"EUR". i.e. enter the text with both semicolons and the quotation marks.

6. Press the Enter key.

7. This completes the entire formula which now reads

=CONVERT(D2;"DEM";"EUR").

8. Cell E2 will contain the result of the calculation.

OpenOffice.org User Guide for 2.x 211

1 2 ... 240 241 242 243 244 245 246 247 248 249 250 ... 507 508

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 245