Export (0) Print
Expand All

2.5.3 Function Token Table

SharePoint

This section specifies the list of functions that can be called from a formula expression. The function display name, ABNF func-name and function type are provided for each function.

Display name

ABNF func-name

Type

Abs

ABS

PtgFunc

ACos

ACOS

PtgFunc

Add

_ADD

PtgFunc

And

AND

PtgFunc

Ang360

ANG360

PtgFunc

ASin

ASIN

PtgFunc

ATan

ATAN

PtgFunc

ATan2

ATAN2

PtgFunc

BitAnd

BITAND

PtgFunc

BitNot

BITNOT

PtgFunc

BitOr

BITOR

PtgFunc

BitXor

BITXOR

PtgFunc

Blend

BLEND

PtgFunc

Bound

BOUND

PtgFuncVar

Ceiling

CEILING

PtgFuncVar

CellIsThemed

CELLISTHEMED

PtgFunc

Char

CHAR

PtgFunc

Cos

COS

PtgFunc

Cat

_CAT

PtgFunc

CosH

COSH

PtgFunc

CY

CY

PtgFunc

Date

DATE

PtgFunc

DateTime

DATETIME

PtgFuncVar

DateValue

DATEVALUE

PtgFuncVar

Day

DAY

PtgFuncVar

DayOfYear

DAYOFYEAR

PtgFuncVar

Deg

DEG

PtgFunc

Div

_DIV

PtgFunc

EEQ

_EEQ

PtgFunc

EGE

_EGE

PtgFunc

EGT

_EGT

PtgFunc

ELE

_ELE

PtgFunc

ELT

_ELT

PtgFunc

ENE

_ENE

PtgFunc

FEQ

_FEQ

PtgFunc

FGE

_FGE

PtgFunc

FGT

_FGT

PtgFunc

Find

FIND

PtgFuncVar

FLE

_FLE

PtgFunc

Floor

FLOOR

PtgFuncVar

FLT

_FLT

PtgFunc

FNE

_FNE

PtgFunc

FormatEx

FORMATEX

PtgFunc

Hour

HOUR

PtgFuncVar

HSL

HSL

PtgFunc

Hue

HUE

PtgFunc

HueDiff

HUEDIFF

PtgFunc

Index

INDEX

PtgFuncVar

Int

INT

PtgFunc

IntersectX

INTERSECTX

PtgFunc

IntersectY

INTERSECTY

PtgFunc

Intup

INTUP

PtgFunc

IsErr

ISERR

PtgFunc

IsErrNA

ISERRNA

PtgFunc

IsError

ISSERROR

PtgFunc

IsErrValue

ISERRVALUE

PtgFunc

Left

LEFT

PtgFuncVar

Len

LEN

PtgFunc

Ln

LN

PtgFunc

Log10

LOG10

PtgFunc

Lookup

LOOKUP

PtgFuncVar

Lower

LOWER

PtgFunc

Lum

LUM

PtgFunc

LumDiff

LUMDIFF

PtgFunc

Magnitude

MAGNITUDE

PtgFunc

Max

MAX

PtgFuncVar

Mid

MID

PtgFunc

Min

MIN

PtgFuncVar

Minute

MINUTE

PtgFuncVar

Modulus

MODULUS

PtgFunc

Month

MONTH

PtgFuncVar

MsoShade

MSOSHADE

PtgFunc

MsoTint

MSOTINT

PtgFunc

Mul

_MUL

PtgFunc

Not

NOT

PtgFunc

Now

NOW

PtgFunc

Or

OR

PtgFunc

Pct

_PCT

PtgFunc

Pi

PI

PtgFunc

Pow

POW

PtgFunc

Pnt

PNT

PtgFunc

Rad

RAD

PtgFunc

Rand

RAND

PtgFunc

Replace

REPLACE

PtgFunc

RGB

RGB

PtgFunc

Right

RIGHT

PtgFuncVar

Round

ROUND

PtgFunc

Sat

SAT

PtgFunc

SatDiff

SATDIFF

PtgFunc

Second

SECOND

PtgFuncVar

SetAtRef

SETATREF

PtgFuncVar

SetAtRefEval

SETATREFEVAL

PtgFunc

SetAtRefExpr

SETATREFEXPR

PtgFuncVar

Shade

SHADE

PtgFunc

ShapeText

SHAPETEXT

PtgFuncVar

Sign

SIGN

PtgFuncVar

Sin

SIN

PtgFunc

SinH

SINH

PtgFunc

Sqrt

SQRT

PtgFunc

StrSame

STRSAME

PtgFuncVar

StrSameEx

STRSAMEEX

PtgFunc

Sub

_SUB

PtgFunc

Substitute

SUBSTITUTE

PtgFuncVar

Sum

SUM

PtgFuncVar

Tan

TAN

PtgFunc

TanH

TANH

PtgFunc

TextHeight

TEXTHEIGHT

PtgFunc

TextWidth

TEXTWIDTH

PtgFunc

Time

TIME

PtgFunc

TimeValue

TIMEVALUE

PtgFuncVar

Tint

TINT

PtgFunc

Tone

TONE

PtgFunc

Trim

TRIM

PtgFunc

Trunc

TRUNC

PtgFunc

UMinus

_UMINUS

PtgFunc

UPlus

_UPLUS

PtgFunc

Upper

UPPER

PtgFunc

WeekDay

WEEKDAY

PtgFuncVar

Year

YEAR

PtgFuncVar

Show:
© 2015 Microsoft