Functions

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.

Complex Number 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

Database Functions

DAVG

DCOUNT

DCOUNTA

DMAX

DMIN

DSTD

DSTDP

DSUM

DVAR

DVARP

Date & Time Functions

DATE

DATEVALUE

DAY

HOUR

MINUTE

MONTH

MONTHDAYS

SECOND

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

YEAR

Financial Functions

CTERM

DDB

FV

IRR

MIRR

PMT

PV

NPV

RATE

SLN

SYD

TERM

Lookup Functions

CHOOSE

HLOOKUP

INDEX

LOOKUP

MATCH

VLOOKUP

Mathematical Functions

ABS

EXP

INT

LN

LOG

MOD

SGN

SQR

SUM

Matrix Functions

M_DETERM

M_INVERSE

M_MULT

TRANSPOSE

Miscellaneous Functions

ALERT

COL

COLS

DEREF

ERROR

IF

INPUT

ROUND

ROW

ROWS

SET_NAME

SET_VALUE

TYPE

VERSION

Statistical Functions

AVG

COUNT

GRAND

GROWTH

LINEST

LOGEST

MAX

MIN

RAND

STD

STDP

TREND

VAR

VARP

String Functions

CHAR

CODE

EXACT

FIND

JOIN

LEFT

LENGTH

LOWER

MID

PROPER

REPLACE

REPT

REVERSE

RIGHT

STRING

TRIM

UPPER

VALUE

Trigonometrical Functions

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