Arithmetic operators define operations on numeric data formats, as well as on Date and Time formats.
Arithmetic operator |
Description |
Example |
|---|---|---|
+ |
Addition |
=6+7 |
− |
Subtraction Negation |
=B12-B3 −45 |
* |
Multiplication |
=86*34 |
/ |
Division |
=36/3 |
^ |
Exponentiation |
=D8^2 |
% |
Percentage calculation |
76% |
V: |
Square root |
=V(9) |
! |
Factorial |
=4! |
Extract the nth root
To extract the root of a number, use the following formula: =M^(1/N), where M is the number from which the root is extracted, N is the root exponent.
For example, the formula =36^(1/2) calculates the square root of 36.