# Operators in LibreOffice Calc

You can use the following operators in LibreOffice Calc:

## Arithmetical Operators

These operators return numerical results.

 Virki Nafn Example + (Plús) Bæta við 1+1 - (Mínus) Frádráttur 2-1 - (Mínus) Neitun -5 * (stjarna) Margföldun 2*2 / (Skástrik) Deiling 9/3 % (Prósenta) Prósenta 15% ^ (ör) Exponentiation 3^2

## Samanburðarvirkjar

These operators return either true or false.

 Virki Nafn Example = (sama sem merki) Líkt A1=B1 > (Stærri en) Stærri en A1>B1 < (minna en merki) Minni en A1= (Stærra en eða jafnt og) Stærra en eða jafnt og A1>=B1 <= (Minna en eða jafnt og) Minna en eða jafnt og A1<=B1 <> (ekki sama sem) Ekki sama sem A1<>B1

## Text operators

The operator combines separate texts into one text.

 Stjórnanda Nafn Example & (Og) text concatenation AND "Sun" & "day" is "Sunday"

## Reference operators

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

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

 Stjórnanda Nafn Example : (tvípunktur) Svið A1:C108 ! (Exclamation point) Skurðflötur 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. ~ (Bylgja) 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. 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.