Apple Numbers '08 Manual do Utilizador descarregar pdf (Página 277)

Chapter 12 Dictionary of Functions 277

SUBSTITUTE

The SUBSTITUTE function replaces a string of characters with new text. You can replace

individual characters, whole words, or strings of characters within words. If a string

occurs more than once in the text, you can specify which occurrences to change.

SUBSTITUTE(text, old, new, [occurrence])

Â text: The text within which you want to replace characters.

Â old: The string of characters you want to replace.

Â new: The string of characters that will replace the old string.

Â occurrence: Optional; specifies which occurrence of the old string is replaced if there

is more than one. If omitted, all occurrences of the string are replaced.

SUM

The SUM function calculates the sum of a set of numbers. The numbers can be in

individual cells, in ranges of cells, or included directly as arguments to the function.

SUM(number, [number, . . .])

Â number: One or more numbers, numeric expressions, or references to a cell or range

of cells containing numbers or numeric expressions.

Examples

SUBSTITUTE("a b c d e f", "b", "B") returns "a B c d e f".

SUBSTITUTE("a a b b b c", "a", "A", 2) returns "a A b b b c".

SUBSTITUTE("a a b b b c", "b", "B") returns "a a B B B c".

SUBSTITUTE("aaabbccc", "bc", "BC", 2) returns "aaabbccc".

Examples

SUM(A1:A4) adds the numbers in four cells.

SUM(A1:D4) adds the numbers in a square array of sixteen cells.

SUM(A1:A4, 100) adds the numbers in four cells plus100.

1 2 ... 272 273 274 275 276 277 278 279 280 281 282 ... 294 295

Sem comentários

Apple Numbers '08 Manual do Utilizador Página 277