Arithmetic operators
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! |
tip
If the value cannot be converted to a number, the operation results in a #VALUE! error.
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.