Series and Scalar Math

 

+ - * / ^ (ARITHMETIC)

Addition

+ - * / ^ (ARITHMETIC)

Subtraction

+ - * / ^ (ARITHMETIC)

Multiplication

+ - * / ^ (ARITHMETIC)

Division

+ - * / ^ (ARITHMETIC)

Exponentiation

ABS

Absolute value

ALL

Return 1 if all elements of the input are non-zero

ANY

Return 1 if any element of the input is non-zero

AVGS

Point by point average of one or more series

BESTPOW2

Find the power of 2 greater than or equal to the input value or length of the input series

CEILING

Round to closest integer

COLPROD

Calculate the product of each column of an array

CUMAVG

Calculate cumulative average

CUMPROD

Calculate cumulative product

CUMSUM

Calculate cumulative sum

CURRENT

Reference series in current window

DEG

Return degrees per radian

E

Euler's number e

EXP

Exponential, base e

EXPM1

Exp(x) - 1 for small x

FACTORIAL

Factorial of positive integers

FACTORS

Return the prime factors of a scalar

FIND

Return indices of non-zero elements or NA if none found

FINDCOL

Return column numbers that meet a condition

FINDMAX

Return X and Y value of the maximum of a series

FINDMIN

Return X and Y value of the minimum of a series

FINDROW

Return row numbers that meet a condition

FINDVAL

Return X and Y values of a series from a specified Y value

FIX

Round a value towards zero

FLOOR

Truncate to closest integer below

INT

Cast scalar as integer

INTERP2

Perform two-dimensional linear interpolation

LN

Natural logarithm, base e

LOG

Natural logarithm, base e

LOG10

Logarithm base 10

LOG1P

Log(1 + x) for small x

LOG2

Logarithm base 2

MAXIDX

Find the index of the maximum value of a series

MAXLOC

Find the location of the maximum value of a series

MAXVAL

Return the maximum of one or two input arguments

MINIDX

Find the index of the minimum value of a series

MINLOC

Find the location of the minimum value of a series

MINVAL

Return the minimum of on or two input arguments

NEGATE

Calculate the arithmetic negative

NIBBLE

Extract a 4 bit nibble from a value

PHI

Macro. "The golden mean" (-1+sqrt(5))/2

PI

Macro. Provides value of π

PROD

Calculate the product of all values of a series or array

REDUCE

Apply operator to all values

REPLACE

Replace values in a series based on a logical condition

ROUND

Round input to nearest integer value

RTHROOT

Generate Complex root (scalar)

SQRT

Square root

SUM

Calculate the scalar sum of a series

SUMS

Point by point sum of one or more series

VAVGS

Point by point average of one ore more inputs without zero padding

VMAX

Return the maximum of one or more input arguments

VMEAN

Return the scalar mean of one or more input arguments

VMIN

Return the minimum of one or more input arguments

VSUM

Return the scalar sum of one or more input arguments

VSUMS

Point by point sum of one or more input arguments without zero padding.

W0

Alternate reference for CURRENT window