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
476 OpenOffice.org 3.x Calc Guide