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

Arithmetic operators

The addition, subtraction, multiplication and division operators return numerical

results. The Negation and Percent operators identify a characteristic of the number

found in the cell, for example -37. The example for Exponentiation illustrates how to

enter a number that is being multiplied by itself a certain number of times, for

example 2

= 2*2*2.

Table 8: Arithmetical operators

Operator Name Example

+ (Plus) Addition =1+1

– (Minus) Subtraction =2–1

– (Minus) Negation –5

* (asterisk) Multiplication =2*2

/ (Slash) Division =10/5

% (Percent) Percent 15%

^ (Caret) Exponentiation 2^3

Comparative operators

Comparative operators are found in formulas that use the IF function and return

either a true or false answer; for example, =IF(B6>G12; 127; 0) which, loosely

translated, means if the contents of cell B6 are greater than the contents of cell G12,

then return the number 127, otherwise return the number 0.

A direct answer of TRUE or FALSE can be obtained by entering a formula such as

=B6>B12. If the numbers found in the referenced cells are accurately represented,

the answer TRUE is returned, otherwise FALSE is returned.

Table 9: Comparative operators

Operator Name Example

= (equal sign) Equal A1=B1

> (Greater than) Greater than A1>B1

< (Less than) Less than A1<B1

>= (Greater than or equal to) Greater than or equal to A1>=B1

<= (Less than or equal to) Less than or equal to A1<=B1

<> (Inequality) Inequality A1<>B1

If cell A1 contains the numerical value 4 and cell B1 the numerical value 5, the above

examples would yield results of FALSE, FALSE, TRUE, FALSE, TRUE, and TRUE.

Text operators

It is common for users to place text in spreadsheets. To provide for variability in what

and how this type of data is displayed, text can be joined together in pieces coming

from different places on the spreadsheet. Figure 142 shows an example.

164 OpenOffice.org 3.3 Calc Guide

1 2 ... 159 160 161 162 163 164 165 166 167 168 169 ... 433 434

Žádné komentáře

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