Tehted LibreOffice Calcis

LibreOffice Calcis on vÔimalik kasutada jÀrgnevaid tehtemÀrke:

Aritmeetilised tehted

Need tehted tagastavad arvulise vÀÀrtuse.

Operator

Name

NĂ€ide

+ (Pluss)

Liitmine

1+1

- (Miinus)

Lahutamine

2-1

- (Miinus)

Lahutamine

-5

* (tÀrn)

Korrutamine

2*2

/ (kaldkriips)

Division

9/3

% (Protsent)

Percent

15%

^ (Katus)

Astendamine

3^2

VÔrdlustehted

Need tehted tagastavad vastuseks kas 'tÔene' vÔi 'vÀÀr'.

Operator

Name

NĂ€ide

= (vÔrdusmÀrk)

VÔrdne

A1=B1

> (Suurem)

Suurem

A1>B1

< (VĂ€iksem)

VĂ€iksem

A1<B1

>= (Suurem vÔi vÔrdne)

Suurem vÔi vÔrdne

A1>=B1

<= (VÀiksem vÔi vÔrdne)

VÀiksem vÔi vÔrdne

A1<=B1

<> (MittevÔrdne)

MittevÔrdne

A1<>B1

Tehted tekstiga

Need tehted liidavad erinevad tekstid ĂŒheks tekstiks.

Operator

Name

NĂ€ide

& (And)

tekstide liitmine & (ja) abil

"PĂŒha" & "pĂ€ev" on "PĂŒhapĂ€ev"

Viitetehted

Need tehted tagastavad vastuseks lahtrite vahemiku nulli, ĂŒhe vĂ”i enama lahtriga.

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

Operator

Name

NĂ€ide

: (Koolon)

Range

A1:C108

! (HĂŒĂŒumĂ€rk)

Intersection

SUM(A1:B6!B5:C12)

Arvutab ĂŒhisosa kĂ”ikide lahtrite summa, kĂ€esolevas nĂ€ites on selleks lahtrite B5 ja B6 summa.

~ (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.

MĂ€rkuse ikoon

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.


Palun toeta meid!