Formulas and Functions

Examples
=FIXED(6789.123, 2) returns “6,789.12.”
=FIXED(6789.123, 1, 1) returns “6789.1.”
=FIXED(6789.123, -2) returns “6,800.”
=FIXED(12.4, 0) returns “12.”
=FIXED(12.5, 0) returns “13.”
=FIXED(4, -1) returns “0.”
=FIXED(5, -1) returns “10.”
Related Topics
For related functions and additional information, see:
“DOLLAR” on page 311
“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
LEFT
The LEFT function returns a string consisting of the specied number of characters
from the left end of a given string.
LEFT(source-string, string-length)
 source-string: A string. source-string is a string value.
 string-length: An optional argument specifying the desired length of the returned
string. string-length is a number value and must be greater than or equal to 1.
Usage Notes
If  string-length is greater than or equal to the length of source-string, the string
returned is equal to source-string.
Examples
=LEFT(”one two three”, 2) returns “on”.
=LEFT(”abc”) returns “a”.
314 Chapter 11 Text Functions