Juniper Systems Allegro DOS Manual User Manual
Page 136
Page 4-70 Windows CE
Tanh(number) Returns the hyperbolic tangent of the number.
Example: Tanh(1) equals 0.76159.
Trunc(number, numDigits) Truncates the number to an integer. The
argument numDigits is the precision of the truncation. The default value
for the numDigits is 0.
Example: Trunc(-7.8) equals -7.
Statistical Functions
Average(number, number, ...) Returns the average of the arguments.
Example: Average(1, 2, 3) equals 2.
Count(number, number, ...) Counts how many numbers are in the list of
arguments.
Example: B1 contains 5, B2 contains 3, Count(B1:B2) equals 2.
CountA(number, number, ...) Counts the number of nonblank values in
the list of arguments.
Example: A1 contains 2, A2 is blank, CountA(A1:A2) equals 1.
CountBlank(range) Counts empty cells in the specified range of cells.
CountIf(range, criteria) Counts the number of cells within the range that
meets the given criteria.
Example: A1 contains 6, A2 contains3, CountIf(A1:A2,”>5") equals 1.
Max(number, number, ...) Returns the maximum value in the list of
arguments.
Example: Max(1, 2, 3) equals 3.
Min(number, number, ...) Returns the minimum value in the list of
arguments.
Example: Min(1, 2, 3) equals 1.
Permut(number, numberChosen) Returns the number of permutations.
Number is the number of objects, numberChosen is the number of
objects in each permutation.
Example: Permut(10, 2) equals 90.
Stdev(number, number, ...) Estimates the standard deviation based on a
sample.
StdevP(number, number, ...) Calculates the standard deviation of the
entire population.
Var(number, number, ...) Estimates the variance based on a sample.
VarP(number, number, ...) Calculates the variance of the entire
population.