Arithmetic operators perform basic operations with numbers in the Number, Date & Time formats. If the value cannot be converted to a number, the operation will result in an error #VALUE!.
Arithmetic operator |
Meaning |
Example |
+ |
Addition |
=6+7 |
- |
Subtraction Negation |
=B12-B3 -45 |
* |
Multiplication |
=86*34 |
/ |
Division |
=36/3 |
^ |
Exponentiation |
=D8^2 |
% |
Percentage |
76% |
Calculate the root
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