Series Functions
Prev
Next
Function Library
Table of Contents
Function Library
+ Control Flow Functions
+ Console I/O Functions
+ Type Conversion and Formatting
- Mathematics and Statistics
+ Basic Math Functions
+ Transcendental Functions
- Series Functions
Arithmetic and Boolean Series Functions
min, max Functions
vmin ..., vmax ...
min, max Functions on Strings
min, max Functions on Numerals
limit
count Functions
+ Matrix Functions
+ Statistics Functions
Conditional Combination Functions
+ Finance and Business Functions
+ String Functions
+ Date and Time Functions
+ Set Functions
+ Table Functions
+ Variables Functions
+ Directory and File System Functions
+ System Functions
+ Help and Support Functions
+ Cross-Functional Info
User Guide
Language Guide
Table Processing
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
Vectorizable min and max functions:
vmax
vmax 123
vmax abc
vmax abc ignore case
vmax numeral
vmax string
vmax string ignore case
vmin
vmin 123
vmin abc
vmin abc ignore case
vmin numeral
vmin string
vmin string ignore case
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
Limit values within lower and upper boundaries:
limit
count functions:
count
count ignore blanks
count ignore both
count ignore zero