PipeDream provides many standard functions to help you to perform calculations within number slots. Most functions take parameters, ie they perform calculations on numbers, dates, strings, etc, which you specify. The following is a brief list of all PipeDream's standard functions. For a detailed description of any individual function, refer to the relevant section.
PipeDream also enables you to create your own functions. See Custom Functions.
C_ACOS
C_ACOSEC
C_ACOSECH
C_ACOSH
C_ACOT
C_ACOTH
C_ADD
C_ASEC
C_ASECH
C_ASIN
C_ASINH
C_ATAN
C_ATANH
C_COS
C_COSEC
C_COSECH
C_COSH
C_COT
C_COTH
C_DIV
C_EXP
C_LN
C_MUL
C_POWER
C_RADIUS
C_SEC
C_SECH
C_SIN
C_SINH
C_SUB
C_TAN
C_TANH
C_THETA
DAVG
DCOUNT
DCOUNTA
DMAX
DMIN
DSTD
DSTDP
DSUM
DVAR
DVARP
AGE
DATE
DATEVALUE
DAY
DAYNAME
HOUR
MINUTE
MONTH
MONTHDAYS
MONTHNAME
SECOND
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUMBER
YEAR
CTERM
DDB
FV
IRR
MIRR
PMT
PV
NPV
RATE
SLN
SYD
TERM
CHOOSE
COL
COLS
HLOOKUP
INDEX
LOOKUP
MATCH
ROW
ROWS
VLOOKUP
ABS
EXP
FACT
INT
LN
LOG
MOD
ROUND
SGN
SQR
SUM
M_DETERM
M_INVERSE
M_MULT
TRANSPOSE
ALERT
DEREF
FLIP
IF
INPUT
SET_NAME
SET_VALUE
SORT
TYPE
VERSION
AVG
BETA
COMBIN
COUNT
GAMMALN
GRAND
GROWTH
LINEST
LISTCOUNT
LOGEST
MAX
MEDIAN
MIN
PERMUT
RAND
RANK
SPEARMAN
STD
STDP
TREND
VAR
VARP
CHAR
CODE
EXACT
FIND
FORMULA_TEXT
JOIN
LEFT
LENGTH
LOWER
MID
PROPER
REPLACE
REPT
REVERSE
RIGHT
STRING
TEXT
TRIM
UPPER
VALUE
ACS
ACOSEC
ACOSECH
ACOSH
ACOT
ACOTH
ASEC
ASECH
ASINH
ASN
ATAN_2
ATANH
ATN
COS
COSEC
COSECH
COSH
COT
COTH
DEG
PI
RAD
SEC
SECH
SIN
SINH
TAN
TANH