Sharp ZAURUS ZR-5000 Specifications download pdf (Page 358)

100

101

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.

1 2 ... 353 354 355 356 357 358 359 360 361 362 363 ... 528 529

Comments to this Manuals

No comments

Sharp ZAURUS ZR-5000 Specifications Page 358

Comments to this Manuals

Related products and manuals for Tablets Sharp ZAURUS ZR-5000