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

Average of n 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

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)

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

Logarithm, (base e)

LOG

Calculate natural logarithm

LOG10

Logarithm, (base 10)

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+(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 sum of a series

SUMS

Sum n series

VMAX

Return the maximum of one or more input arguments

VMIN

Return the minimum of one or more input arguments

W0

Alternate reference for CURRENT window