Arithmetic operators perform arithmetic operations in formulas.
To do this
Use this arithmetic operator
Examples, when A2 contains 20 and B2 contains 2
Add two values
+ (plus sign)
A2 + B2 returns 22
Subtract one value from another value
– (minus sign)
A2 – B2 returns 18
Multiply two values
* (asterisk)
A2 * B2 returns 40
Divide one value by another value
/ (forward slash)
A2 / B2 returns 10
Raise one value to the power of another value
^ (caret)
A2 ^ B2 returns 400
Calculate a percentage
% (per cent sign)
A2% returns 0.2, formatted for display as 20%
Using a string with an arithmetic operator returns an error. For example, 3 + "hello" is not a correct arithmetic operation.