If you're familiar with Excel formulas, you can use them in Dashpivot to perform calculations, automate templates, analyse data, and streamline your forms.
You can learn the full functionality of each formula on the official Microsoft Excel support site, as Dashpivot formulas follow the same syntax and behaviour.
For help getting started, see our guide: How to use Dashpivot formulas.
Below is the complete list of supported formulas, organised by category for easy reference.
List of formulas according to common type/use:
Date and Time Formulas
Date and Time Formulas
DATE
DATEDIF
DATEVALUE
DAY
DAYS
DAYS360
EDATE
EOMONTH
HOUR
INTERVAL
ISOWEEKNUM
MINUTE
MONTH
NETWORKDAYS
NETWORKDAYS. INTL
NOW
SECOND
TIME
TIMEDIF
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
YEAR
YEARFRAC
Financial Formulas
Financial Formulas
DOLLARDE
DOLLARFR
ISPMT
NOMINAL
NPER
NPV
PDURATION
SLN
XNPV
Information Formulas
Information Formulas
ISBLANK
ISEVEN
ISLOGICAL
ISNOTTEXT
ISNUMBER
ISODD
ISTEXT
Logical Formulas
Logical Formulas
AND
FALSE
IF
IFS
IFNA
IFERROR
NOT
SWITCH
OR
TRUE
XOR
Lookup and Reference Formulas
Lookup and Reference Formulas
CHOOSE
COLUMN
COLUMNS
HLOOKUP
INDEX
MATCH
OFFSET
ROW
ROWS
VLOOKUP
Math and Trigonometry Formulas
Math and Trigonometry Formulas
ABS
ARABIC
BASE
CEILING
CEILING.MATH
CEILING.PRECISE
COMBIN
COMBINA
COS
COT
COUNUNIQUE
CSC
CSCH
DECIMAL
DEGREES
EVEN
FLOOR
GCD
INT
LCM
LN
LOG
LOG10
MOD
MROUND
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDBETWEEN
ROUND
ROUNDDOWN
ROUNDUP
SEC
SECH
SERIESSUM
SIN
SINH
SIGN
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMSQ
TAN
TANH
TRUNC
Matrix Formulas
Matrix Formulas
MEDIANPOOL
MAXPOOL
TRANSPOSE
Operator Formulas
Operator Formulas
HF.ADD
HF.DIVIDE
HF.EQ
HF.LTE
HF.LT
HF.GTE
HF.MINUS
HF.MULTIPLY
HF.NE
HF.POW
Statistical Formulas
Statistical Formulas
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COVARIANCE.P
COVARIANCE.S
DEVSQ
EXPON.DIST
EXPONDIST
GAUSS
GEOMEAN
HARMEAN
LARGE
MAX
MAXA
MEDIAM
MIN
MINA
SKEW
SKEW.P
SKEWP
SLOPE
SMALL
STEDEV
STDEVA
STDEVP
STDEV.P
STDEVPA
STDEV.S
STDEV.S
VARA
VARP
VARPA
VAR.S
VARS
Text Formulas
Text Formulas
CLEAN
CODE
CONCATENATE
EXACT
FIND
LEFT
LEN
LOWER
MIND
PROPER
REPLACE
REPT
RIGHT
SEARCH
SPLIT
SUBSTITUTE
T
TEXT
TRIM
UNICHAR
UNICODE
UPPER