Scroll

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+)


Hidden Article Information

Article Author
Nick
created 2015-12-24 18:19:08 UTC
updated 2017-11-14 20:18:37 UTC

Labels
List of Functions, All Functions, functions,
Have more questions? Submit a request