How can we help you?

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%

If the value cannot be converted to a number, the operation will result in an error #VALUE!.

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