Loading ...
Loading ...
Loading ...
95
Relational functions
Relational functions operate on numeric values,
references to numeric values, and labels.
value1 < value2 Returns TRUE if value1 is less than
value2, FALSE otherwise.
Example: 5<7 returns TRUE.
value1 <= value2 Returns TRUE if value1 is less than or
equal to value2, FALSE otherwise.
Example: 8<=10 returns TRUE.
value1 <> value2 Returns TRUE if value1 is not equal to
value2, FALSE if value1 equals
value2.
Example: 3<>6 returns TRUE.
value1 = value2 Returns TRUE if value1 equals
value2, FALSE otherwise.
Example: 5=2 returns FALSE.
value1 > value2 Returns TRUE if value1 is greater
than value2, FALSE otherwise.
Example: 8>8 returns FALSE.
value1 >= value2 Returns TRUE if value1 is greater
than or equal to value2, FALSE
otherwise.
Example: 9>=3 returns TRUE.
Statistical functions
For statistical functions that accept a list of values as
arguments, the values can be any combination of
numbers, numeric formulas, cell references, and cell
ranges.
AVERAGE(values...)
Returns the average of the values.
Example: AVERAGE(79, 83, 92, 82,
90) returns 85.2.
COUNT(values...)
Counts how many numbers (including
date and time values) are in the
argument list.
Example: COUNT( C2:E2) returns 1
where C2 contains “a label”, D2 is
empty and E2 contains 15.6.
COUNTA(values...)
Counts how many non-empty cells are
in the argument list.
Example: COUNT( C2:E2) returns 2
where C2 contains “a label”, D2 is
empty and E2 contains 15.6.
Loading ...
Loading ...
Loading ...