Apple numbers User Manual

 Using Formulas and Functions in Tables

 

Arithmetic operators in table cell formulas perform arithmetic operations and return 
numerical results. 

m

The operator + returns the sum of two values.

For example, A2 + B2 returns 22.

m

The operator – returns the difference between two values.

For example A2 – B2 returns 18.

m

The operator * returns the product of two values.

For example, A2 * B2 returns 40.

m

The operator / returns the result of dividing one value by another value.

For example, A2/B2 returns 10.

m

The operator ^ returns the result of raising one value to the power of another value.

For example, A2 ^ B2 returns 400.

m

The operator % returns the result of dividing a value by 100.

For example, A2% returns 0.2, formatted for display as 20%.

When a cell reference points to an empty cell, 0 is the value used.

When a cell reference points to a cell containing FALSE, 0 is used. If the cell contains 
TRUE, 1 is used. For example, TRUE + 1 returns 2.

Using a string with an arithmetic operator returns an error. For example, 3 + "hello" is 
not a correct arithmetic operation.