# Operators in LibreOffice Calc

You can use the following operators in LibreOffice Calc:

## Arithmetic Operators

These operators return numeric results.

Operator |
Name |
Example |

+ (Plus) |
Addition |
1+1 |

- (Minus) |
Subtraction |
2-1 |

- (Minus) |
Negation |
-5 |

* (asterisk) |
Multiplication |
2*2 |

/ (Slash) |
Division |
9/3 |

% (Percent) |
Percent |
15% |

^ (Caret) |
Exponentiation |
3^2 |

## Comparative operators

These operators return either true or false.

Operator |
Name |
Example |

= (equal sign) |
Equal |
A1=B1 |

> (Greater than) |
Greater than |
A1>B1 |

< (Less than) |
Less than |
A1<B1 |

>= (Greater than or equal to) |
Greater than or equal to |
A1>=B1 |

<= (Less than or equal to) |
Less than or equal to |
A1<=B1 |

<> (Inequality) |
Inequality |
A1<>B1 |

## Text operators

The operator combines separate text strings into one text string.

Operator |
Name |
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.

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.