Spreadsheet Formulas - Numeric Functions

Statistica provides a predefined broad selection of numeric and logical functions that can be used in spreadsheet formulas like all other functions.

Below is a list of numeric and logical spreadsheet functions (parameters are given in parentheses).
  

Floor(number) Returns the largest integer less than or equal to its argument. For example:

Floor(2.7) results in 2, but Floor(-0.5) results in 1

Ceiling(number) Returns the smallest integer greater than or equal to its argument. For example:

Ceiling(2.3) results in 3

Ceiling(-2.3) results in -2

Round(number, dec) Rounds the first argument to the number of decimal places given by the second argument. For example:

Round(3.554, 2) rounds to 3.55

Round(3.555, 2) rounds to 3.56

Round(4.5, 0) rounds to 5*

FACT(number) Truncates its numeric argument to an integer and returns the factorial of this integer.
COMBIN(n, k) Returns the number of combinations of n things taken k at a time, n!/k!(n - k)!
PERMUT(n, k) Returns the number of permutations of n items taken k at a time, n!/(n - k)!
CHOOSE(i, V1, V2, …, Vn) Returns the ith value, Vi. This function accepts arguments as numeric or text.
MATCH(value, V1, R1, V2, R2, …, Vn, Rn [, Rdefault]) If value = Vi, returns Ri, or returns Rdefault (if specified). Otherwise, returns missing data.
IN(val, list-val1, [list-val2, list-val3, …]) Returns a non-zero value (true) if the first argument is equal to any of the remaining arguments. All arguments may be constants, variable references, or expressions and works with text or numbers.

*Round(4.5, 0) in a Statistica spreadsheet or in Excel yields 5 (Arithmetic rounding); in Statistica Visual Basic or Visual Basic, this formula yields 4 (Banker's rounding, that is, rounds .5 either up or down, whichever results in an even number).

See also: Distributions and their Functions, Spreadsheet Formulas - Overview, Spreadsheet Formulas - Syntax Summary, Spreadsheet Formulas - Examples, Spreadsheet Formulas - Syntax Operators, Spreadsheet Formulas - Distributions and their Functions.