All built-in functions are listed here. Click on a function for more information.
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 & 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
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
PageNumber