Arithmetic operators perform basic operations with numbers in the Number, Date, and Time formats.
Arithmetic operator |
Meaning |
Example |
|---|---|---|
+ |
Addition |
=6+7 |
- |
Subtraction Negation |
=B12-B3 -45 |
* |
Multiplication |
=86*34 |
/ |
Division |
=36/3 |
^ |
Exponentiation |
=D8^2 |
% |
Percentage |
76% |
To calculate the root of a number, use the formula: =М^(1/N), where М is the number you want to find the root of and N is the root index. For example, this formula =36^(1/2) extracts the square root of 36. |