XLL+ Class Library (6.3)

Excel built-in function numbers (Numeric order)

The table below lists all the Excel built-in functions. The value in the Number column should be used as an argument to CXlOper::Excel() and CXllApp::Excel().

To see the usage of the built-in functions, refer to Excel on-line help, or search MSDN for the following string (making sure that you retain the quotes):

"Microsoft Excel Macro Functions Contents" and "Listed by category"

The functions below are divided into two sections:

Worksheet functions Functions that can be called from worksheet cells
Command-equivalent functions Functions that can only be called from macro functions

Worksheet functions

Function Number
COUNT 0
ISNA 2
ISERROR 3
SUM 4
AVERAGE 5
MIN 6
MAX 7
ROW 8
COLUMN 9
NA 10
NPV 11
STDEV 12
DOLLAR 13
FIXED 14
SIN 15
COS 16
TAN 17
ATAN 18
PI 19
SQRT 20
EXP 21
LN 22
LOG10 23
ABS 24
INT 25
SIGN 26
ROUND 27
LOOKUP 28
INDEX 29
REPT 30
MID 31
LEN 32
VALUE 33
TRUE 34
FALSE 35
AND 36
OR 37
NOT 38
MOD 39
DCOUNT 40
DSUM 41
DAVERAGE 42
DMIN 43
DMAX 44
DSTDEV 45
VAR 46
DVAR 47
TEXT 48
LINEST 49
TREND 50
LOGEST 51
GROWTH 52
GOTO 53
HALT 54
PV 56
FV 57
NPER 58
PMT 59
RATE 60
MIRR 61
IRR 62
RAND 63
MATCH 64
DATE 65
TIME 66
DAY 67
MONTH 68
YEAR 69
WEEKDAY 70
HOUR 71
MINUTE 72
SECOND 73
NOW 74
AREAS 75
ROWS 76
COLUMNS 77
OFFSET 78
ABSREF 79
RELREF 80
ARGUMENT 81
SEARCH 82
TRANSPOSE 83
ERROR 84
STEP 85
TYPE 86
ECHO 87
SETNAME 88
CALLER 89
DEREF 90
WINDOWS 91
SERIES 92
DOCUMENTS 93
ACTIVECELL 94
SELECTION 95
RESULT 96
ATAN2 97
ASIN 98
ACOS 99
CHOOSE 100
HLOOKUP 101
VLOOKUP 102
LINKS 103
INPUT 104
ISREF 105
GETFORMULA 106
GETNAME 107
SETVALUE 108
LOG 109
EXEC 110
CHAR 111
LOWER 112
UPPER 113
PROPER 114
LEFT 115
RIGHT 116
EXACT 117
TRIM 118
REPLACE 119
SUBSTITUTE 120
CODE 121
NAMES 122
DIRECTORY 123
FIND 124
CELL 125
ISERR 126
ISTEXT 127
ISNUMBER 128
ISBLANK 129
T 130
N 131
FOPEN 132
FCLOSE 133
FSIZE 134
FREADLN 135
FREAD 136
FWRITELN 137
FWRITE 138
FPOS 139
DATEVALUE 140
TIMEVALUE 141
SLN 142
SYD 143
DDB 144
GETDEF 145
REFTEXT 146
TEXTREF 147
INDIRECT 148
REGISTER 149
CALL 150
ADDBAR 151
ADDMENU 152
ADDCOMMAND 153
ENABLECOMMAND 154
CHECKCOMMAND 155
RENAMECOMMAND 156
SHOWBAR 157
DELETEMENU 158
DELETECOMMAND 159
GETCHARTITEM 160
DIALOGBOX 161
CLEAN 162
MDETERM 163
MINVERSE 164
MMULT 165
FILES 166
IPMT 167
PPMT 168
COUNTA 169
CANCELKEY 170
INITIATE 175
REQUEST 176
POKE 177
EXECUTE 178
TERMINATE 179
RESTART 180
HELP 181
GETBAR 182
PRODUCT 183
FACT 184
GETCELL 185
GETWORKSPACE 186
GETWINDOW 187
GETDOCUMENT 188
DPRODUCT 189
ISNONTEXT 190
GETNOTE 191
NOTE 192
STDEVP 193
VARP 194
DSTDEVP 195
DVARP 196
TRUNC 197
ISLOGICAL 198
DCOUNTA 199
DELETEBAR 200
UNREGISTER 201
USDOLLAR 204
FINDB 205
SEARCHB 206
REPLACEB 207
LEFTB 208
RIGHTB 209
MIDB 210
LENB 211
ROUNDUP 212
ROUNDDOWN 213
ASC 214
DBCS 215
RANK 216
ADDRESS 219
DAYS360 220
TODAY 221
VDB 222
MEDIAN 227
SUMPRODUCT 228
SINH 229
COSH 230
TANH 231
ASINH 232
ACOSH 233
ATANH 234
DGET 235
CREATEOBJECT 236
VOLATILE 237
LASTERROR 238
CUSTOMUNDO 239
CUSTOMREPEAT 240
FORMULACONVERT 241
GETLINKINFO 242
TEXTBOX 243
INFO 244
GROUP 245
GETOBJECT 246
DB 247
PAUSE 248
RESUME 251
FREQUENCY 252
ADDTOOLBAR 253
DELETETOOLBAR 254
RESETTOOLBAR 256
EVALUATE 257
GETTOOLBAR 258
GETTOOL 259
SPELLINGCHECK 260
ERRORTYPE 261
APPTITLE 262
WINDOWTITLE 263
SAVETOOLBAR 264
ENABLETOOL 265
PRESSTOOL 266
REGISTERID 267
GETWORKBOOK 268
AVEDEV 269
BETADIST 270
GAMMALN 271
BETAINV 272
BINOMDIST 273
CHIDIST 274
CHIINV 275
COMBIN 276
CONFIDENCE 277
CRITBINOM 278
EVEN 279
EXPONDIST 280
FDIST 281
FINV 282
FISHER 283
FISHERINV 284
FLOOR 285
GAMMADIST 286
GAMMAINV 287
CEILING 288
HYPGEOMDIST 289
LOGNORMDIST 290
LOGINV 291
NEGBINOMDIST 292
NORMDIST 293
NORMSDIST 294
NORMINV 295
NORMSINV 296
STANDARDIZE 297
ODD 298
PERMUT 299
POISSON 300
TDIST 301
WEIBULL 302
SUMXMY2 303
SUMX2MY2 304
SUMX2PY2 305
CHITEST 306
CORREL 307
COVAR 308
FORECAST 309
FTEST 310
INTERCEPT 311
PEARSON 312
RSQ 313
STEYX 314
SLOPE 315
TTEST 316
PROB 317
DEVSQ 318
GEOMEAN 319
HARMEAN 320
SUMSQ 321
KURT 322
SKEW 323
ZTEST 324
LARGE 325
SMALL 326
QUARTILE 327
PERCENTILE 328
PERCENTRANK 329
MODE 330
TRIMMEAN 331
TINV 332
MOVIECOMMAND 334
GETMOVIE 335
CONCATENATE 336
POWER 337
PIVOTADDDATA 338
GETPIVOTTABLE 339
GETPIVOTFIELD 340
GETPIVOTITEM 341
RADIANS 342
DEGREES 343
SUBTOTAL 344
SUMIF 345
COUNTIF 346
COUNTBLANK 347
SCENARIOGET 348
OPTIONSLISTSGET 349
ISPMT 350
DATEDIF 351
DATESTRING 352
NUMBERSTRING 353
ROMAN 354
OPENDIALOG 355
SAVEDIALOG 356

Command-equivalent functions

Function Number
BEEP 32768
OPEN 32769
OPENLINKS 32770
CLOSEALL 32771
SAVE 32772
SAVEAS 32773
FILEDELETE 32774
PAGESETUP 32775
PRINT 32776
PRINTERSETUP 32777
QUIT 32778
NEWWINDOW 32779
ARRANGEALL 32780
WINDOWSIZE 32781
WINDOWMOVE 32782
FULL 32783
CLOSE 32784
RUN 32785
SETPRINTAREA 32790
SETPRINTTITLES 32791
SETPAGEBREAK 32792
REMOVEPAGEBREAK 32793
FONT 32794
DISPLAY 32795
PROTECTDOCUMENT 32796
PRECISION 32797
A1R1C1 32798
CALCULATENOW 32799
CALCULATION 32800
DATAFIND 32802
EXTRACT 32803
DATADELETE 32804
SETDATABASE 32805
SETCRITERIA 32806
SORT 32807
DATASERIES 32808
TABLE 32809
FORMATNUMBER 32810
ALIGNMENT 32811
STYLE 32812
BORDER 32813
CELLPROTECTION 32814
COLUMNWIDTH 32815
UNDO 32816
CUT 32817
COPY 32818
PASTE 32819
CLEAR 32820
PASTESPECIAL 32821
EDITDELETE 32822
INSERT 32823
FILLRIGHT 32824
FILLDOWN 32825
DEFINENAME 32829
CREATENAMES 32830
FORMULAGOTO 32831
FORMULAFIND 32832
SELECTLASTCELL 32833
SHOWACTIVECELL 32834
GALLERYAREA 32835
GALLERYBAR 32836
GALLERYCOLUMN 32837
GALLERYLINE 32838
GALLERYPIE 32839
GALLERYSCATTER 32840
COMBINATION 32841
PREFERRED 32842
ADDOVERLAY 32843
GRIDLINES 32844
SETPREFERRED 32845
AXES 32846
LEGEND 32847
ATTACHTEXT 32848
ADDARROW 32849
SELECTCHART 32850
SELECTPLOTAREA 32851
PATTERNS 32852
MAINCHART 32853
OVERLAY 32854
SCALE 32855
FORMATLEGEND 32856
FORMATTEXT 32857
EDITREPEAT 32858
PARSE 32859
JUSTIFY 32860
HIDE 32861
UNHIDE 32862
WORKSPACE 32863
FORMULA 32864
FORMULAFILL 32865
FORMULAARRAY 32866
DATAFINDNEXT 32867
DATAFINDPREV 32868
FORMULAFINDNEXT 32869
FORMULAFINDPREV 32870
ACTIVATE 32871
ACTIVATENEXT 32872
ACTIVATEPREV 32873
UNLOCKEDNEXT 32874
UNLOCKEDPREV 32875
COPYPICTURE 32876
SELECT 32877
DELETENAME 32878
DELETEFORMAT 32879
VLINE 32880
HLINE 32881
VPAGE 32882
HPAGE 32883
VSCROLL 32884
HSCROLL 32885
ALERT 32886
NEW 32887
CANCELCOPY 32888
SHOWCLIPBOARD 32889
MESSAGE 32890
PASTELINK 32892
APPACTIVATE 32893
DELETEARROW 32894
ROWHEIGHT 32895
FORMATMOVE 32896
FORMATSIZE 32897
FORMULAREPLACE 32898
SENDKEYS 32899
SELECTSPECIAL 32900
APPLYNAMES 32901
REPLACEFONT 32902
FREEZEPANES 32903
SHOWINFO 32904
SPLIT 32905
ONWINDOW 32906
ONDATA 32907
DISABLEINPUT 32908
ECHO 32909
OUTLINE 32910
LISTNAMES 32911
FILECLOSE 32912
SAVEWORKBOOK 32913
DATAFORM 32914
COPYCHART 32915
ONTIME 32916
WAIT 32917
FORMATFONT 32918
FILLUP 32919
FILLLEFT 32920
DELETEOVERLAY 32921
NOTE 32922
SHORTMENUS 32923
SETUPDATESTATUS 32927
COLORPALETTE 32929
DELETESTYLE 32930
WINDOWRESTORE 32931
WINDOWMAXIMIZE 32932
ERROR 32933
CHANGELINK 32934
CALCULATEDOCUMENT 32935
ONKEY 32936
APPRESTORE 32937
APPMOVE 32938
APPSIZE 32939
APPMINIMIZE 32940
APPMAXIMIZE 32941
BRINGTOFRONT 32942
SENDTOBACK 32943
MAINCHARTTYPE 32953
OVERLAYCHARTTYPE 32954
SELECTEND 32955
OPENMAIL 32956
SENDMAIL 32957
STANDARDFONT 32958
CONSOLIDATE 32959
SORTSPECIAL 32960
GALLERY3DAREA 32961
GALLERY3DCOLUMN 32962
GALLERY3DLINE 32963
GALLERY3DPIE 32964
VIEW3D 32965
GOALSEEK 32966
WORKGROUP 32967
FILLGROUP 32968
UPDATELINK 32969
PROMOTE 32970
DEMOTE 32971
SHOWDETAIL 32972
UNGROUP 32974
OBJECTPROPERTIES 32975
SAVENEWOBJECT 32976
SHARE 32977
SHARENAME 32978
DUPLICATE 32979
APPLYSTYLE 32980
ASSIGNTOOBJECT 32981
OBJECTPROTECTION 32982
HIDEOBJECT 32983
SETEXTRACT 32984
CREATEPUBLISHER 32985
SUBSCRIBETO 32986
ATTRIBUTES 32987
SHOWTOOLBAR 32988
PRINTPREVIEW 32990
EDITCOLOR 32991
SHOWLEVELS 32992
FORMATMAIN 32993
FORMATOVERLAY 32994
ONRECALC 32995
EDITSERIES 32996
DEFINESTYLE 32997
LINEPRINT 33008
ENTERDATA 33011
GALLERYRADAR 33017
MERGESTYLES 33018
EDITIONOPTIONS 33019
PASTEPICTURE 33020
PASTEPICTURELINK 33021
SPELLING 33022
ZOOM 33024
RESUME 33026
INSERTOBJECT 33027
WINDOWMINIMIZE 33028
SIZE 33029
MOVE 33030
SOUNDNOTE 33033
SOUNDPLAY 33034
FORMATSHAPE 33035
EXTENDPOLYGON 33036
FORMATAUTO 33037
GALLERY3DBAR 33040
GALLERY3DSURFACE 33041
FILLAUTO 33042
CUSTOMIZETOOLBAR 33044
ADDTOOL 33045
EDITOBJECT 33046
ONDOUBLECLICK 33047
ONENTRY 33048
WORKBOOKADD 33049
WORKBOOKMOVE 33050
WORKBOOKCOPY 33051
WORKBOOKOPTIONS 33052
SAVEWORKSPACE 33053
CHARTWIZARD 33056
DELETETOOL 33057
MOVETOOL 33058
WORKBOOKSELECT 33059
WORKBOOKACTIVATE 33060
ASSIGNTOTOOL 33061
COPYTOOL 33063
RESETTOOL 33064
CONSTRAINNUMERIC 33065
PASTETOOL 33066
PLACEMENT 33068
FILLWORKGROUP 33069
WORKBOOKNEW 33070
SCENARIOCELLS 33073
SCENARIODELETE 33074
SCENARIOADD 33075
SCENARIOEDIT 33076
SCENARIOSHOW 33077
SCENARIOSHOWNEXT 33078
SCENARIOSUMMARY 33079
PIVOTTABLEWIZARD 33080
PIVOTFIELDPROPERTIES 33081
PIVOTFIELD 33082
PIVOTITEM 33083
PIVOTADDFIELDS 33084
OPTIONSCALCULATION 33086
OPTIONSEDIT 33087
OPTIONSVIEW 33088
ADDINMANAGER 33089
MENUEDITOR 33090
ATTACHTOOLBARS 33091
VBARESET 33092
OPTIONSCHART 33093
START 33094
VBAEND 33095
VBAINSERTFILE 33096
VBAPROCEDUREDEFINITION 33098
VBAREFERENCES 33099
VBASTEPINTO 33100
VBASTEPOVER 33101
VBATOGGLEBREAKPOINT 33102
VBACLEARBREAKPOINTS 33103
ROUTINGSLIP 33104
ROUTEDOCUMENT 33106
MAILLOGON 33107
INSERTPICTURE 33110
EDITTOOL 33111
GALLERYDOUGHNUT 33112
VBAOBJECTBROWSER 33113
VBADEBUGWINDOW 33114
VBAADDWATCH 33115
VBAEDITWATCH 33116
VBAINSTANTWATCH 33117
CHARTTREND 33118
PIVOTITEMPROPERTIES 33120
WORKBOOKINSERT 33122
OPTIONSTRANSITION 33123
OPTIONSGENERAL 33124
FILTERADVANCED 33138
MAILADDMAILER 33141
MAILDELETEMAILER 33142
MAILREPLY 33143
MAILREPLYALL 33144
MAILFORWARD 33145
MAILNEXTLETTER 33146
DATALABEL 33147
INSERTTITLE 33148
FONTPROPERTIES 33149
MACROOPTIONS 33150
WORKBOOKHIDE 33151
WORKBOOKUNHIDE 33152
WORKBOOKDELETE 33153
WORKBOOKNAME 33154
GALLERYCUSTOM 33156
ADDCHARTAUTOFORMAT 33158
DELETECHARTAUTOFORMAT 33159
CHARTADDDATA 33160
AUTOOUTLINE 33161
TABORDER 33162
SHOWDIALOG 33163
SELECTALL 33164
UNGROUPSHEETS 33165
SUBTOTALCREATE 33166
SUBTOTALREMOVE 33167
RENAMEOBJECT 33168
WORKBOOKSCROLL 33180
WORKBOOKNEXT 33181
WORKBOOKPREV 33182
WORKBOOKTABSPLIT 33183
FULLSCREEN 33184
WORKBOOKPROTECT 33185
SCROLLBARPROPERTIES 33188
PIVOTSHOWPAGES 33189
TEXTTOCOLUMNS 33190
FORMATCHARTTYPE 33191
LINKFORMAT 33192
TRACERDISPLAY 33193
TRACERNAVIGATE 33198
TRACERCLEAR 33199
TRACERERROR 33200
PIVOTFIELDGROUP 33201
PIVOTFIELDUNGROUP 33202
CHECKBOXPROPERTIES 33203
LABELPROPERTIES 33204
LISTBOXPROPERTIES 33205
EDITBOXPROPERTIES 33206
PIVOTREFRESH 33207
LINKCOMBO 33208
OPENTEXT 33209
HIDEDIALOG 33210
SETDIALOGFOCUS 33211
ENABLEOBJECT 33212
PUSHBUTTONPROPERTIES 33213
SETDIALOGDEFAULT 33214
FILTER 33215
FILTERSHOWALL 33216
CLEAROUTLINE 33217
FUNCTIONWIZARD 33218
ADDLISTITEM 33219
SETLISTITEM 33220
REMOVELISTITEM 33221
SELECTLISTITEM 33222
SETCONTROLVALUE 33223
SAVECOPYAS 33224
OPTIONSLISTSADD 33226
OPTIONSLISTSDELETE 33227
SERIESAXES 33228
SERIESX 33229
SERIESY 33230
ERRORBARX 33231
ERRORBARY 33232
FORMATCHART 33233
SERIESORDER 33234
MAILLOGOFF 33235
CLEARROUTINGSLIP 33236
APPACTIVATEMICROSOFT 33237
MAILEDITMAILER 33238
ONSHEET 33239
STANDARDWIDTH 33240
SCENARIOMERGE 33241
SUMMARYINFO 33242
FINDFILE 33243
ACTIVECELLFONT 33244
ENABLETIPWIZARD 33245
VBAMAKEADDIN 33246
MAILSENDMAILER 33250

See Also

Excel built-in function numbers (Alphabetical order) | Walkthrough: Calling an Excel built-in function from your add-in