Series Functions
Prev
Next
Function Library Guide
Table of Contents
1 Function Library
+ 2 Control Flow Functions
+ 3 Console I/O Functions
+ 4 Type Conversion and Formatting
5 Mathematics and Statistics
+ 5.1 Basic Math Functions
+ 5.2 Transcendental Functions
5.3 Series Functions
5.3.1 Arithmetic and Boolean Series Functions
5.3.2 min, max Functions
5.3.3 min, max Functions on Strings
5.3.4 min, max Functions on Numerals
5.3.5 count Functions
+ 5.4 Matrix Functions
+ 5.5 Statistics Functions
5.6 Conditional Combination Functions
+ 5.7 Finance and Business Functions
+ 6 String Functions
+ 7 Date and Time Functions
+ 8 Parameter Set Functions
+ 9 Table Functions
+ 10 Variables Functions
+ 11 Directory and File System Functions
+ 12 System Functions
+ 13 Help and Support Functions
+ 14 Cross-Functional Info
→ User Guide
→ Language Guide
Index
Introduction
This section covers all functions which can process value series of variable sizes.
Procedures and Functions Provided:
Arithmetic and Boolean Series Functions, Two parameter passing methods for series functions:
add
and
div
mul
or
sub
xnor
xor
min and max functions:
max
max ignore blanks
max ignore zero
max ignore zero
min
min ignore blanks
min and max functions on strings:
max abc
max abc ignore case
max string
max string ignore case
min abc
min abc ignore blanks
min abc ignore both
min abc ignore case
min string
min string ignore blanks
min string ignore both
min string ignore case
min and max functions on numerals:
max 123
max 124 ignore zero
max numeral
max numeral ignore zero
min 123
min 123 ignore zero
min numeral
min numeral ignore zero
count functions:
count
count ignore blanks
count ignore both
count ignore zero