# List of Functions

All built-in functions are listed here. Click on a function for more information.

# Aggregate

AggAvg
AggCount
AggDistinctCount
AggMax
AggMin
AggSum
RunningSum
AggMedian (v2017.2+)
AggMode (v2017.2+)
AggStandardDeviation (v2017.2+)
AggVariance (v2017.2+)

# Financial

DB
DDB
Fv
Intrate
Ipmt
Nper
Npv
Pmt
Ppmt
Pv
Rate
Sln
Syd

# Date

Date
DateAdd
DateDiff
DateValue
Day
Days360
GlobalDateFormat
GlobalDateTimeFormat
Hour
Minute
Month
Now
Second
Time
TimeFormat1
TimeValue
Today
Year
MonthName (v2017.2+)
QuarterNumber (v2017.2+)
QuarterName (v2017.2+)

# Arithmetic & Geometric

Absolute
Acos
Acosh
Asin
Asinh
Atan
Atan2
Atanh
Ceiling
Cos
Cosh
Even
Exp
Fixed
Floor
GlobalNumericFormat
Int
Ln
Log
Log10
Mod
Odd
Pi
Power
Product
Quotient
Rand
Sin
Sinh
Sqrt
Tan
Tanh
Truncate

# Formatting

Bold
Italic
Underline

# String

Concatenate
Left
Len
Lower
Mid
NewLine
Replace
Right
Trim
Upper
Value

# Operators

& (and)

+ (plus)

- (minus)

* (multiplied by)

/ (divided by)

# Logical

And
False
If
Not
Or
Switch
True

# Database & Data Type

DataRowCount
IsEven
IsLogical
IsNoDataQualified
IsNonText
IsNumber
IsOdd
IsText
Null
Type

# Other

FilterValue
LoadImage
CellValue
Hyperlink
StripHTMLTag
ExcelFormula
ExportType (v2017.2+)
PageNumber (v2017.2+)