Juniper Systems Allegro CX Manual - Manual (Page 150)

150 Allegro CX Owner’s Manual
Rand()
Returns a random number greater than or equal to 0 and less than 1.
A new number is returned every time the workbook is recalculated.
Round(number, number)
Rounds a number to the specifi ed number of digits.
Example: Round(5.46, 1) equals 5.5.
RoundDown(number, numDigits)
Rounds the number down, toward zero, to the specifi ed number of
digits.
Example: RoundDown(40.8, 0) equals 40.
RoundUp(number, numDigits)
Rounds the number up, away from zero, to the specifi ed number of
digits.
Example: RoundUp(39.1, 0) equals 40.
Sign(number)
Returns 1 if the number is positive, 0 if the number is 0, and -1 if the
number is negative.
Example: Sign(-5) equals -1.
Sin(number)
Returns the sine of the given angle.
Example: Sin(Pi()/2) equals 1.
Sinh(number)
Returns the hyperbolic sine of the number.
Example: Sinh(3) equals 10.01787.
Sqrt(number)
Returns the square root.
Example: Sqrt(4) equals 2.
Subtotal(functionNumber, ref1, ref2, …)
Returns a subtotal. Nested subtotals and fi ltered hidden rows
are ignored. FunctionNumber specifi es which function to use in
calculation subtotals (1-Average, 2-Count, 3-Counta, 4-Max, 5-Min,
6-Product, 7-Stdev, 8-Stdevp, 9-Sum, 10-Var, 11-Varp).
Example: Subtotal(9,A1:A3) will calculate a subtotal of the cells A1:
A3 using the Sum function.