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

Some of these functions overlap; for example, MIN and MAX are both covered by

QUARTILE. In other cases, a custom sort or filter might give much the same result.

Which you use depends on your temperament and your needs. Some might prefer to

use MIN and MAX because they are easy to remember, while others might prefer

QUARTILE because it is more versatile.

Using these functions

In some cases, you may be able to get similar results to some of these functions by

setting up a filter or a custom sort. However, in general, functions are more easily

adjusted than filters or sorts, and provide a wide range of possibilities.

At times, you may just want to enter one or more formulas temporarily in a

convenient blank cell, and delete it once you have finished. However, if you find

yourself using the same functions constantly, you should consider creating a template

and including space for all the functions you use, with the cell to their left used as a

label for them. Once you have created the template, you can easily update each

formula as entries change, either automatically and on-the-fly or pressing the F9 key

to update all selected cells.

No matter how you use these functions, you will probably find them simple to use and

adaptable for many purposes. By the time you have mastered this handful, you will be

ready to try more complex functions.

Rounding off numbers

For statistical and mathematical purposes, Calc includes a variety of ways to round

off numbers. If you’re a programmer, you may also be familiar with some of these

methods. However, you don’t need to be a specialist to find some of these methods

useful. You may want to round off for billing purposes, or because decimal places

don’t translate well into the physical world—for instance, if the parts you need come

in packages of 100, then the fact you only need 66 is irrelevant to you; you need to

round up for ordering. By learning the options for rounding up or down, you can

make your spreadsheets more immediately useful.

When you use a rounding function, you have two choices about how to set up your

formulas. If you choose, you can nest a calculation within one of the rounding

functions. For instance, the formula =ROUND((SUM(A1;A2)) adds the figures in cells

A1 and A2, then rounds them off to the nearest whole number. However, even though

you don’t need to work with exact figures every day, you may still want to refer to

them occasionally. If that is the case, then you are probably better off separating the

two functions, placing =SUM(A1;A2) in cell A3, and =ROUND (A3) in A4, and clearly

labelling each function.

Rounding methods

The most basic function for rounding numbers in Calc is ROUND. This function will

round off a number according to the usual rules of symmetric arithmetic rounding: a

decimal place of .4 or less gets rounded down, while one of .5 or more gets rounded

up. However, at times, you may not want to follow these rules. For instance, if you are

one of those contractors who bills a full hour for any fraction of an hour you work,

you would want to always round up so you didn’t lose any money. Conversely, you

might choose to round down to give a slight discount to a long-established customer.

In these cases, you might prefer to use ROUNDUP or ROUNDDOWN, which, as their

names suggest, round a number to the nearest integer above or below it.

Chapter 7 Using Formulas and Functions 189

1 2 ... 184 185 186 187 188 189 190 191 192 193 194 ... 433 434

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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