Calc Guide

Syntax Description
DECIMAL(text; radix) Converts text with characters from a number system
to a positive integer in the base radix given. The radix
must be in the range 2 to 36. Spaces and tabs are
ignored. The text field is not case-sensitive. Text is
the text to be converted. To differentiate between a
hexadecimal number, such as A1 and the reference to
cell A1, place the number in quotation marks; for
example, "A1" or "FACE”. Radix is the base of the
number system. It may be any positive integer
between 2 and 36.
DOLLAR(value; decimals) Converts a number to an amount in the currency
format, rounded to a specified decimal place. Value is
the number to be converted to currency; it can be a
number, a reference to a cell containing a number, or
a formula which returns a number. Decimals
(optional) is the number of decimal places. If no
decimals value is specified, all numbers in currency
format will be displayed with two decimal places. The
currency format is set in the system settings.
EXACT(text_1; text_2) Compares two text strings and returns TRUE if they
are identical. This function is case-sensitive. Text_1 is
the first text to compare. Text_2 is the second text to
compare.
FIND(find_text; text;
position)
Looks for a string of text within another string. Where
to begin the search can also be defined. The search
term can be a number or any string of characters.
The search is case-sensitive. Find_text is the text to
be found. Text is the text where the search takes
place. Position (optional) is the position in the text
from which the search starts.
FIXED(number; decimals;
no_thousands_separator)
Specifies that a number be displayed with a fixed
number of decimal places and with or without a
thousands separator. This function can be used to
apply a uniform format to a column of numbers.
Number is the number to be formatted. Decimals is
the number of decimal places to be displayed.
No_thousands_separator (optional) determines
whether the thousands separator is used or not. If the
parameter is a number not equal to 0, the thousands
separator is suppressed. If the parameter is equal to
0 or if it is missing altogether, the thousands
separators of the current locale setting are displayed.
LEFT(text; number) Returns the first character or characters in a text
string. Text is the text where the initial partial words
are to be determined. Number (optional) is the
number of characters for the start text. If this
parameter is not defined, one character is returned.
LEN(text)
Returns the length of a string including spaces. Text
is the text whose length is to be determined.
Appendix B Description of Functions 415