# Operators in LibreOffice Calc

You can use the following operators in LibreOffice Calc:

## Arithmetical Operators

These operators return numerical results.

 Operator Ime Example + (Plus) Addition 1+1 - (Minus) Subtraction 2-1 - (Minus) Negation -5 * (asterisk) Multiplication 2*2 / (Slash) Dijeljenje (÷) 9/3 % (Percent) Percent 15% ^ (Caret) Exponentiation 3^2

## Comparative operators

These operators return either true or false.

 Operator Ime Example = (equal sign) Jednako A1=B1 veće od veće od A1>B1 < (Less than) manje od A1=B1 manje ili jednako manje ili jednako A1<=B1 <> (Inequality) Inequality A1<>B1

## Text operators

The operator combines separate texts into one text.

 Operator Ime Example & (And) 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.

 Operator Ime Example : (Colon) Opseg A1:C108 ! (Exclamation point) Presjek 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. 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!
{"ft_lang_label":"__label__en","ft_lang_prob":0.67412686,"math_prob":0.73192847,"size":1684,"snap":"2021-21-2021-25","text_gpt3_token_len":519,"char_repetition_ratio":0.12559524,"word_repetition_ratio":0.03883495,"special_character_ratio":0.30225652,"punctuation_ratio":0.097122304,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9792208,"pos_list":[0,1,2],"im_url_duplicate_count":[null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-06-21T21:36:53Z\",\"WARC-Record-ID\":\"<urn:uuid:417affd4-c12d-41f1-86cb-858f4aae74ca>\",\"Content-Length\":\"15818\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:b41013eb-b2de-4058-ba7e-7e17cf45bee6>\",\"WARC-Concurrent-To\":\"<urn:uuid:970f16f0-5c69-4fc6-9bdd-99215bc5bb3d>\",\"WARC-IP-Address\":\"89.238.68.190\",\"WARC-Target-URI\":\"https://help.libreoffice.org/latest/bs/text/scalc/01/04060199.html\",\"WARC-Payload-Digest\":\"sha1:2GFF5BHSQ7NMYJZZMVNX2X25GN5GTIYX\",\"WARC-Block-Digest\":\"sha1:LFJVQ4CMRZYYS7VEPBAQ4YSAYJ7IW4GL\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-25/CC-MAIN-2021-25_segments_1623488504838.98_warc_CC-MAIN-20210621212241-20210622002241-00465.warc.gz\"}"}