OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 330)

Calc functions similar to database functions

Although every Calc function can be used for database manipulation, the functions in

Table 17 are more commonly used as such. Some functions’ names differ only by the

letter appended at the end; AVERAGE and AVERAGEA, for example. Functions that

do not end with the letter A operate only on numeric values and cells that contain

text or are empty are ignored. The corresponding function whose name ends with the

letter A, treats text values as a number with the value of zero; blank cells are still

ignored.

Table 17. Functions frequently used as database functions.

Function Description

AVERAGE Return the average. Ignore empty cells and cells that contain

text.

AVERAGEA Return the average. The value of text is 0 and empty cells are

ignored.

COUNT Count the number of numeric entries; text entries are ignored.

COUNTA Count the number of non-empty entries.

COUNTBLANK Return the number of empty cells.

COUNTIF Return the number of cells that meet the search criteria.

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.

330 OpenOffice.org 3.3 Calc Guide

1 2 ... 325 326 327 328 329 330 331 332 333 334 335 ... 433 434

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 330