Formulas and Functions

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 rst 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 rst “e” found starting from character 8, the
“n” in “on”).
Related Topics
For related functions and additional information, see:
“EXACT” on page 312
“SEARCH” on page 320
“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 specied 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 specied number of places, round-half-up is used. If the most
signicant 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.