# 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 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 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 MOD Remainder from division 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