OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 187)

We are concerned that the number shown in Cell C3 is incorrectly stated. The cause

can be seen in the highlighted cells. In this case cell C16 contains both numeric data

as well as letters. Removing the letters resolves the problem in the calculation.

In other cases we must trace the error. Use the Trace Error function, found under

Tools > Detective > Trace Error, to find the cells that cause the error.

Examples of functions

For novices, functions are one of the most intimidating features of OpenOffice.org's

Calc. New users quickly learn that functions are an important feature of

spreadsheets, but there are almost four hundred, and many require input that

assumes specialized knowledge. Fortunately, Calc includes dozens of functions that

anyone can use.

Basic arithmetic and statistic functions

The most basic functions create formulas for basic arithmetic or for evaluating

numbers in a range of cells.

Basic arithmetic

The simple arithmetic functions are addition, subtraction, multiplication, and division.

Except for subtraction, each of these operations has its own function:

• SUM for addition

• PRODUCT for multiplication

• QUOTIENT for division

Traditionally, subtraction does not have a function.

SUM, PRODUCT, and QUOTIENT are useful for entering ranges of cells in the same

way as any other function, with arguments in brackets after the function name.

However, for basic equations, many users prefer the time-honored computer symbols

for these operations, using the plus sign (+) for addition, the hyphen (–) for

subtraction, the asterisk (*) for multiplication and the forward slash (/) for division.

These symbols are quick to enter without requiring your hands to stray from the

keyboard.

A similar choice is also available if you want to raise a number by the power of

another. Instead of entering =POWER(A1;2), you can enter =A1^2.

Moreover, they have the advantage that you enter formulas with them in an order

that more closely approximates human readable format than the spreadsheet-

readable format used by the equivalent function. For instance, instead of entering

=SUM (A1:A2), or possibly =SUM (A1;A2), you enter =A1+A2. This almost-human

readable format is especially useful for compound operations, where writing

=A1*(A2+A3) is briefer and easier to read than =PRODUCT(A1;SUM(A2:A3)).

The main disadvantage of using arithmetical operators is that you cannot directly use

a range of cells. In other words, to enter the equivalent of =SUM (A1:A3), you would

need to type =A1+A2+A3.

Otherwise, whether you use a function or an operator is largely up to you—except, of

course, when you are subtracting. However, if you use spreadsheets regularly in a

group setting such as a class or an office, you might want to standardize on an entry

Chapter 7 Using Formulas and Functions 187

1 2 ... 182 183 184 185 186 187 188 189 190 191 192 ... 433 434

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 187

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3