Operators in LibreOffice Calc

You can use the following operators in LibreOffice Calc:

Arithmetical Operators

These operators return numerical results.

Operators

Nosaukums

Example

+ (Plus)

Saskaitīšana

1+1

- (MÄ«nus)

Atņemšana

2-1

- (MÄ«nus)

Negācija

-5

* (zvaigznīte)

Reizināšana

2*2

/ (Slīpsvītra)

Dalīšana

9/3

% (Procents)

Procenti

15%

^ (Caret)

Exponentiation

3^2


Comparative operators

These operators return either true or false.

Operators

Nosaukums

Example

= (vienādības zīme)

Vienāds

A1=B1

> (lielāks kā)

Lielāks kā

A1>B1

< (Mazāks kā)

Mazāks kā

A1<B1

>= (lielāks kā vai vienāds ar)

Lielāks kā vai vienāds ar

A1>=B1

<= (mazāks kā vai vienāds ar)

Mazāks kā vai vienāds ar

A1<=B1

<> (Nevienādība)

Nevienādība

A1<>B1


Teksta operatori

The operator combines separate texts into one text.

Operators

Nosaukums

Example

& (And)

text concatenation AND

"Sun" & "day" is "Sunday"


Atsauces operatori

These operators return a cell range of zero, one or more cells.

Range has the highest precedence, then intersection, and then finally union.

Operators

Nosaukums

Example

: (Colon)

Diapazons

A1:C108

! (Exclamation point)

Šķēlums

SUM(A1:B6!B5:C12)

Calculates the sum of all cells in the intersection; in this example, the result yields the sum of cells B5 and B6.

~ (Tilde)

Concatenation or union

Takes two references and returns a reference list, which is a concatenation of the left reference followed by the right reference. Double entries are referenced twice. See note below this table.


Piezīmes ikona

Reference concatenation using a tilde character was implemented lately. When a formula with the tilde operator exists in a document that is opened in old versions of the software, an error is returned. A reference list is not allowed inside an array expression.


Please support us!