Apple Numbers '08 Manual de usuario descargar pdf (Pagina 95)

Chapter 5 Using Formulas and Functions in Tables 95

Understanding the Arithmetic Operators

Arithmetic operators in table cell formulas perform arithmetic operations and return

numerical results.

Here are the arithmetic operators (examples presume that cell A2 contains 20 and

that B2 contains 2):

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.

1 2 ... 90 91 92 93 94 95 96 97 98 99 100 ... 294 295

Sin comentarios

Apple Numbers '08 Manual de usuario Pagina 95