Theory:

Operators in LibreOffice Calc:

An operator is a character or set of characters that determine the action that is to be performed or considered.
 
Some of the operators in LibreOffice Calc are:
  • Arithmetic
  • Relational
  • Logical
Arithmetic Operators:

Arithmetic operators are used to do some kind of calculations with numeric values. We cannot use them with strings.
 
Operator
Name
Example
\(+ (Plus)\)
Addition
\(=15+12\)
\(- (Minus)\)
Subtraction
\(=15-12\)
\(- (Minus)\)
Negation
\(=-5\)
\(* (asterisk)\)
Multiplication
\(=5*4\)
\(/ (Slash)\)
Division
\(=8/2\)
\(\%\) \((Percent)\)
Percent
\(=15\%\)
\(^ (Caret)\)
Exponentiation
\(=3^2\)
 
Example:
Addition:
 
add.jpg
 
Subtraction:
 
sub.jpg
 
Multiplication:
 
mul.jpg
 
Division:
 
div.jpg
 
Percent:
 
Percent.jpg
 
Exponentiation:
 
Exp.jpg