List of Functions

All built-in functions are listed here. Click on a function header for more info on those functions.

Aggregate

AggAvg
AggCount
AggDistinctCount
AggMax
AggMin
AggSum
RunningSum
AggMedian
AggMode
AggStandardDeviation
AggVariance

 

Financial

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

 

Date

Date
DateAdd
DateCustomFormat
DateDiff
DateValue
Day
Days360
GlobalDateFormat
GlobalDateTimeFormat
Hour
Minute
Month
Now
Second
Time
TimeFormat1
TimeValue
Today
Year
MonthName
QuarterNumber
QuarterName

 

Arithmetic and 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 and Data Type

DataRowCount
IsEven
IsLogical
IsNoDataQualified
IsNonText
IsNumber
IsOdd
IsText
Null
Type

 

Other

FilterValue
LoadImage
CellValue
Hyperlink
StripHTMLTag
ExcelFormula
ExportType
PageNumber