# Operators in LibreOffice Calc

You can use the following operators in LibreOffice Calc:

## OperatĂ«rot Unar/Binar

These operators return numerical results.

 Operator Emri Shembull Plus Mbledhja + 1+1 - (Minus) Zbritja - 2-1 - (Minus) Negation -5 * (asterisk) ShumĂ«zimi (x) 2*2 PjesĂ«tim (/) PjesĂ«tim (Ă·) 9/3 % (Percent) PĂ«rqindja 15% ^ (Caret) Exponentiation 3^2

## OperatĂ«rot Unar/Binar

These operators return either true or false.

 Operator Emri Shembull ĂshtĂ« baraz me Baraz A1=B1 mĂ« e madhe se mĂ« e madhe se A1>B1 mĂ« pak se mĂ« pak se A1=B1 mĂ« pak se ose barazi me mĂ« pak se ose barazi me A1<=B1 <> (Inequality) Inequality A1<>B1

## Vizato tekstin

The operator combines separate texts into one text.

 Operator Emri Shembull dhe Teksti PerĂ«ndimor dhe pikĂ«zimi Aziatik "Sun" & "day" is "Sunday"

## Deri nĂ« referencĂ«

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

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

 Operator Emri Shembull : (Colon) Brez A1:C108 ShĂ«ni pikĂ«n Prerje 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. Karakteri ~ ~Prano ose Refuzo... 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.

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.