Calc Guide

Function Description
HLOOKUP Search for a specific value across the columns in the first
row of an array. Return the value from a different row in
the same column.
INDEX Return the content of a cell, specified by row and column
number or an optional range name.
INDIRECT Return the reference specified by a text string.
LOOKUP Return the contents of a cell either from a one-row or
one-column range or from an array.
MATCH Search an array and return the relative position of the
found item.
MAX Return the maximum numeric value in a list of
arguments.
MAXA Return the maximum numeric value in a list of
arguments. The value of text is 0.
MIN Return the minimum numeric value in a list of arguments.
MINA Return the minimum numeric value in a list of arguments.
The value of text is 0.
MEDIAN Return the median of a set of numbers.
MODE Return the most common value in a data set. If there are
several values with the same frequency, it returns the
smallest value. An error occurs when a value doesn’t
appear twice.
OFFSET Return the value of a cell offset by a certain number of
rows and columns from a given reference point.
PRODUCT Return the product of the cells.
STDEV Estimate the standard deviation based on a sample.
STDEVA Estimate the standard deviation based on a sample. The
value of text is 0.
STDEVP Calculate the standard deviation based on the entire
population.
STDEVPA Calculate the standard deviation based on the entire
population.
SUBTOTAL Calculate a specified function based on a subset created
using AutoFilters.
SUM Return the sum of the cells.
376 OpenOffice.org 3.x Calc Guide