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 |
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 |
Function | Number |
---|---|
BEEP | 32768 |
OPEN | 32769 |
OPENLINKS | 32770 |
CLOSEALL | 32771 |
SAVE | 32772 |
SAVEAS | 32773 |
FILEDELETE | 32774 |
PAGESETUP | 32775 |
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 |
Excel built-in function numbers (Alphabetical order) | Walkthrough: Calling an Excel built-in function from your add-in