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

Was this helpful?
Yes
No
Next
Comparison operators