OpenOffice.org OpenOffice - 3.2 Guide de base télécharger pdf (Page 213)

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

Chapter 7 Using Formulas and Functions 213

1 2 ... 208 209 210 211 212 213 214 215 216 217 218 ... 496 497

Pas de commentaire

OpenOffice.org OpenOffice - 3.2 Guide de base Page 213