Fixed, 313 fixed – Apple iWork '09 User Manual
Page 313
Chapter 11
Text Functions
313
Specifying
Â
start-pos permits you to begin the search for search-string within, rather
than at the beginning of, source-string. This is particularly useful if source-string may
contain multiple instances of search-string and you wish to determine the starting
position of other than the first instance. If start-pos is omitted, it is assumed to be 1.
Examples
=FIND(”e”, “where on earth”) returns 3 (”e” is the third character in the string “where on earth”).
=FIND(”e”, “where on earth”, 8) returns 10 (”e” in earth is the first “e” found starting from character 8, the
“n” in “on”).
Related Topics
For related functions and additional information, see:
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
FIXED
The FIXED function rounds a number to the specified number of decimal places and
then returns the result as a string value.
FIXED(num, places, no-commas)
Â
num: The number to be used. num is a number value.
Â
places: An optional argument indicating the number of places to the right, or left,
of the decimal point at which rounding should occur. places is a number value.
When rounding to the specified number of places, round-half-up is used. If the most
significant digit being dropped is 5 or greater, the result is rounded up. A negative
number indicates rounding should occur to the left of the decimal (for example,
round to hundreds or thousands).
Â
no-commas: An optional argument indicating whether to use position separators in
the whole portion of the resulting number.
use commas (FALSE, 0, or omitted): Include position separators in the result.
no commas (TRUE or 1): Don’t include position separators in the result.