OpenOffice.org 2.x Guía de usuario Pagina 178

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 508
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 177
Chapter 3: Managing Text Documents With Writer
List
Separator
|
Separates the elements in a list.
Example of using a list:
MIN 10|20|50|<C6>|<A2:B6>|20
Equal
EQ or
==
Checks if selected values are equal. If they are unequal, the
result is zero, otherwise 1 (true) appears.
Example: <A1> EQ 2 displays 1, if the content of A1
equals 2.
Not Equal
NEQ
or !=
Tests for inequality between selected values.
Example: <A1> NEQ 2 displays 0 (wrong), if the content
of A1 equals 2.
Less than or
Equal
LEQ
Tests for values less than or equal to a specified value.
Example: <A1> LEQ 2 displays 1 (true), if the content of
A1 is less than or equal to 2.
Greater than
or Equal
GEQ
Tests for values greater than or equal to a specified value
Example: <A1> GEQ 2 displays 1 (true), if the content of
A1 is greater than or equal to 2.
Less
L
Tests for values less than a specified value
Example: <A1> L 2 displays 1 (true), if the content of A1
is less than 2.
Greater
G
Tests for values greater than a specified value
Example: <A1> G 2 displays 1 (true), if the content of A1
is greater than 2.
Boolean Or
OR
Tests for values matching the Boolean OR
Example: 0 OR 0 displays 0 (false), anything else results
in 1 (true)
Boolean X
Or
XOR
Tests for values matching the Boolean exclusive OR
Example: 1 XOR 0 displays 1 (true)
Boolean And
AND
Tests for values matching the Boolean AND
Example: 1 AND 2 displays 1 (true)
Boolean Not
NOT
Tests for values matching the Boolean NOT
Example: NOT 1 (true) displays 0 (false)
Statistical Functions
Choose from the following statistical functions:
Mean
MEAN
Calculates the arithmetic mean of the values in an area or a
list.
Example: MEAN 10|30|20 displays 20
Minimum
Value
MIN
Calculates the minimum value in an area or a list.
Example: MIN 10|30|20 displays 10
Maximum
Value
MAX
Calculates the maximum value in an area or a list.
Example: MAX 10|30|20 displays 30.00
Trigonometric Functions
Choose from the following trigonometric functions:
OpenOffice.org User Guide for 2.x 144
Vista de pagina 177
1 2 ... 173 174 175 176 177 178 179 180 181 182 183 ... 507 508

Comentarios a estos manuales

Sin comentarios