Excel内部関数一覧
| index | 関数名 |
|---|---|
| 001 | xlfCount |
| 002 | xlfIsna |
| 003 | xlfIserror |
| 004 | xlfSum |
| 005 | xlfAverage |
| 006 | xlfMin |
| 007 | xlfMax |
| 008 | xlfRow |
| 009 | xlfColumn |
| 010 | xlfNa |
| 011 | xlfNpv |
| 012 | xlfStdev |
| 013 | xlfDollar |
| 014 | xlfFixed |
| 015 | xlfSin |
| 016 | xlfCos |
| 017 | xlfTan |
| 018 | xlfAtan |
| 019 | xlfPi |
| 020 | xlfSqrt |
| 021 | xlfExp |
| 022 | xlfLn |
| 023 | xlfLog10 |
| 024 | xlfAbs |
| 025 | xlfInt |
| 026 | xlfSign |
| 027 | xlfRound |
| 028 | xlfLookup |
| 029 | xlfIndex |
| 030 | xlfRept |
| 031 | xlfMid |
| 032 | xlfLen |
| 033 | xlfValue |
| 034 | xlfTrue |
| 035 | xlfFalse |
| 036 | xlfAnd |
| 037 | xlfOr |
| 038 | xlfNot |
| 039 | xlfMod |
| 040 | xlfDcount |
| 041 | xlfDsum |
| 042 | xlfDaverage |
| 043 | xlfDmin |
| 044 | xlfDmax |
| 045 | xlfDstdev |
| 046 | xlfVar |
| 047 | xlfDvar |
| 048 | xlfText |
| 049 | xlfLinest |
| 050 | xlfTrend |
| 051 | xlfLogest |
| 052 | xlfGrowth |
| 053 | xlfGoto |
| 054 | xlfHalt |
| 055 | xlfPv |
| 056 | xlfFv |
| 057 | xlfNper |
| 058 | xlfPmt |
| 059 | xlfRate |
| 060 | xlfMirr |
| 061 | xlfIrr |
| 062 | xlfRand |
| 063 | xlfMatch |
| 064 | xlfDate |
| 065 | xlfTime |
| 066 | xlfDay |
| 067 | xlfMonth |
| 068 | xlfYear |
| 069 | xlfWeekday |
| 070 | xlfHour |
| 071 | xlfMinute |
| 072 | xlfSecond |
| 073 | xlfNow |
| 074 | xlfAreas |
| 075 | xlfRows |
| 076 | xlfColumns |
| 077 | xlfOffset |
| 078 | xlfAbsref |
| 079 | xlfRelref |
| 080 | xlfArgument |
| 081 | xlfSearch |
| 082 | xlfTranspose |
| 083 | xlfError |
| 084 | xlfStep |
| 085 | xlfType |
| 086 | xlfEcho |
| 087 | xlfSetName |
| 088 | xlfCaller |
| 089 | xlfDeref |
| 090 | xlfWindows |
| 091 | xlfSeries |
| 092 | xlfDocuments |
| 093 | xlfActiveCell |
| 094 | xlfSelection |
| 095 | xlfResult |
| 096 | xlfAtan2 |
| 097 | xlfAsin |
| 098 | xlfAcos |
| 099 | xlfChoose |
| 100 | xlfHlookup |
| 101 | xlfVlookup |
| 102 | xlfLinks |
| 103 | xlfInput |
| 104 | xlfIsref |
| 105 | xlfGetFormula |
| 106 | xlfGetName |
| 107 | xlfSetValue |
| 108 | xlfLog |
| 109 | xlfExec |
| 110 | xlfChar |
| 111 | xlfLower |
| 112 | xlfUpper |
| 113 | xlfProper |
| 114 | xlfLeft |
| 115 | xlfRight |
| 116 | xlfExact |
| 117 | xlfTrim |
| 118 | xlfReplace |
| 119 | xlfSubstitute |
| 120 | xlfCode |
| 121 | xlfNames |
| 122 | xlfDirectory |
| 123 | xlfFind |
| 124 | xlfCell |
| 125 | xlfIserr |
| 126 | xlfIstext |
| 127 | xlfIsnumber |
| 128 | xlfIsblank |
| 129 | xlfT |
| 130 | xlfN |
| 131 | xlfFopen |
| 132 | xlfFclose |
| 133 | xlfFsize |
| 134 | xlfFreadln |
| 135 | xlfFread |
| 136 | xlfFwriteln |
| 137 | xlfFwrite |
| 138 | xlfFpos |
| 139 | xlfDatevalue |
| 140 | xlfTimevalue |
| 141 | xlfSln |
| 142 | xlfSyd |
| 143 | xlfDdb |
| 144 | xlfGetDef |
| 145 | xlfReftext |
| 146 | xlfTextref |
| 147 | xlfIndirect |
| 148 | xlfRegister |
| 149 | xlfCall |
| 150 | xlfAddBar |
| 151 | xlfAddMenu |
| 152 | xlfAddCommand |
| 153 | xlfEnableCommand |
| 154 | xlfCheckCommand |
| 155 | xlfRenameCommand |
| 156 | xlfShowBar |
| 157 | xlfDeleteMenu |
| 158 | xlfDeleteCommand |
| 159 | xlfGetChartItem |
| 160 | xlfDialogBox |
| 161 | xlfClean |
| 162 | xlfMdeterm |
| 163 | xlfMinverse |
| 164 | xlfMmult |
| 165 | xlfFiles |
| 166 | xlfIpmt |
| 167 | xlfPpmt |
| 168 | xlfCounta |
| 169 | xlfCancelKey |
| 170 | xlfInitiate |
| 171 | xlfRequest |
| 172 | xlfPoke |
| 173 | xlfExecute |
| 174 | xlfTerminate |
| 175 | xlfRestart |
| 176 | xlfHelp |
| 177 | xlfGetBar |
| 178 | xlfProduct |
| 179 | xlfFact |
| 180 | xlfGetCell |
| 181 | xlfGetWorkspace |
| 182 | xlfGetWindow |
| 183 | xlfGetDocument |
| 184 | xlfDproduct |
| 185 | xlfIsnontext |
| 186 | xlfGetNote |
| 187 | xlfNote |
| 188 | xlfStdevp |
| 189 | xlfVarp |
| 190 | xlfDstdevp |
| 191 | xlfDvarp |
| 192 | xlfTrunc |
| 193 | xlfIslogical |
| 194 | xlfDcounta |
| 195 | xlfDeleteBar |
| 196 | xlfUnregister |
| 197 | xlfUsdollar |
| 198 | xlfFindb |
| 199 | xlfSearchb |
| 200 | xlfReplaceb |
| 201 | xlfLeftb |
| 202 | xlfRightb |
| 203 | xlfMidb |
| 204 | xlfLenb |
| 205 | xlfRoundup |
| 206 | xlfRounddown |
| 207 | xlfAsc |
| 208 | xlfDbcs |
| 209 | xlfRank |
| 210 | xlfAddress |
| 211 | xlfDays360 |
| 212 | xlfToday |
| 213 | xlfVdb |
| 214 | xlfMedian |
| 215 | xlfSumproduct |
| 216 | xlfSinh |
| 217 | xlfCosh |
| 218 | xlfTanh |
| 219 | xlfAsinh |
| 220 | xlfAcosh |
| 221 | xlfAtanh |
| 222 | xlfDget |
| 223 | xlfCreateObject |
| 224 | xlfVolatile |
| 225 | xlfLastError |
| 226 | xlfCustomUndo |
| 227 | xlfCustomRepeat |
| 228 | xlfFormulaConvert |
| 229 | xlfGetLinkInfo |
| 230 | xlfTextBox |
| 231 | xlfInfo |
| 232 | xlfGroup |
| 233 | xlfGetObject |
| 234 | xlfDb |
| 235 | xlfPause |
| 236 | xlfResume |
| 237 | xlfFrequency |
| 238 | xlfAddToolbar |
| 239 | xlfDeleteToolbar |
| 240 | xlfResetToolbar |
| 241 | xlfEvaluate |
| 242 | xlfGetToolbar |
| 243 | xlfGetTool |
| 244 | xlfSpellingCheck |
| 245 | xlfErrorType |
| 246 | xlfAppTitle |
| 247 | xlfWindowTitle |
| 248 | xlfSaveToolbar |
| 249 | xlfEnableTool |
| 250 | xlfPressTool |
| 251 | xlfRegisterId |
| 252 | xlfGetWorkbook |
| 253 | xlfAvedev |
| 254 | xlfBetadist |
| 255 | xlfGammaln |
| 256 | xlfBetainv |
| 257 | xlfBinomdist |
| 258 | xlfChidist |
| 259 | xlfChiinv |
| 260 | xlfCombin |
| 261 | xlfConfidence |
| 262 | xlfCritbinom |
| 263 | xlfEven |
| 264 | xlfExpondist |
| 265 | xlfFdist |
| 266 | xlfFinv |
| 267 | xlfFisher |
| 268 | xlfFisherinv |
| 269 | xlfFloor |
| 270 | xlfGammadist |
| 271 | xlfGammainv |
| 272 | xlfCeiling |
| 273 | xlfHypgeomdist |
| 274 | xlfLognormdist |
| 275 | xlfLoginv |
| 276 | xlfNegbinomdist |
| 277 | xlfNormdist |
| 278 | xlfNormsdist |
| 279 | xlfNorminv |
| 280 | xlfNormsinv |
| 281 | xlfStandardize |
| 282 | xlfOdd |
| 283 | xlfPermut |
| 284 | xlfPoisson |
| 285 | xlfTdist |
| 286 | xlfWeibull |
| 287 | xlfSumxmy2 |
| 288 | xlfSumx2my2 |
| 289 | xlfSumx2py2 |
| 290 | xlfChitest |
| 291 | xlfCorrel |
| 292 | xlfCovar |
| 293 | xlfForecast |
| 294 | xlfFtest |
| 295 | xlfIntercept |
| 296 | xlfPearson |
| 297 | xlfRsq |
| 298 | xlfSteyx |
| 299 | xlfSlope |
| 300 | xlfTtest |
| 301 | xlfProb |
| 302 | xlfDevsq |
| 303 | xlfGeomean |
| 304 | xlfHarmean |
| 305 | xlfSumsq |
| 306 | xlfKurt |
| 307 | xlfSkew |
| 308 | xlfZtest |
| 309 | xlfLarge |
| 310 | xlfSmall |
| 311 | xlfQuartile |
| 312 | xlfPercentile |
| 313 | xlfPercentrank |
| 314 | xlfMode |
| 315 | xlfTrimmean |
| 316 | xlfTinv |
| 317 | xlfMovieCommand |
| 318 | xlfGetMovie |
| 319 | xlfConcatenate |
| 320 | xlfPower |
| 321 | xlfPivotAddData |
| 322 | xlfGetPivotTable |
| 323 | xlfGetPivotField |
| 324 | xlfGetPivotItem |
| 325 | xlfRadians |
| 326 | xlfDegrees |
| 327 | xlfSubtotal |
| 328 | xlfSumif |
| 329 | xlfCountif |
| 330 | xlfCountblank |
| 331 | xlfScenarioGet |
| 332 | xlfOptionsListsGet |
| 333 | xlfIspmt |
| 334 | xlfDatedif |
| 335 | xlfDatestring |
| 336 | xlfNumberstring |
| 337 | xlfRoman |
| 338 | xlfOpenDialog |
| 339 | xlfSaveDialog |
| 340 | xlfViewGet |
| 341 | xlfGetpivotdata |
| 342 | xlfHyperlink |
| 343 | xlfPhonetic |
| 344 | xlfAveragea |
| 345 | xlfMaxa |
| 346 | xlfMina |
| 347 | xlfStdevpa |
| 348 | xlfVarpa |
| 349 | xlfStdeva |
| 350 | xlfVara |
| 351 | xlfBahttext |
| 352 | xlfThaidayofweek |
| 353 | xlfThaidigit |
| 354 | xlfThaimonthofyear |
| 355 | xlfThainumsound |
| 356 | xlfThainumstring |
| 357 | xlfThaistringlength |
| 358 | xlfIsthaidigit |
| 359 | xlfRoundbahtdown |
| 360 | xlfRoundbahtup |
| 361 | xlfThaiyear |
| 362 | xlfRtd |
| 363 | xlfCubevalue |
| 364 | xlfCubemember |
| 365 | xlfCubememberproperty |
| 366 | xlfCuberankedmember |
| 367 | xlfHex2bin |
| 368 | xlfHex2dec |
| 369 | xlfHex2oct |
| 370 | xlfDec2bin |
| 371 | xlfDec2hex |
| 372 | xlfDec2oct |
| 373 | xlfOct2bin |
| 374 | xlfOct2hex |
| 375 | xlfOct2dec |
| 376 | xlfBin2dec |
| 377 | xlfBin2oct |
| 378 | xlfBin2hex |
| 379 | xlfImsub |
| 380 | xlfImdiv |
| 381 | xlfImpower |
| 382 | xlfImabs |
| 383 | xlfImsqrt |
| 384 | xlfImln |
| 385 | xlfImlog2 |
| 386 | xlfImlog10 |
| 387 | xlfImsin |
| 388 | xlfImcos |
| 389 | xlfImexp |
| 390 | xlfImargument |
| 391 | xlfImconjugate |
| 392 | xlfImaginary |
| 393 | xlfImreal |
| 394 | xlfComplex |
| 395 | xlfImsum |
| 396 | xlfImproduct |
| 397 | xlfSeriessum |
| 398 | xlfFactdouble |
| 399 | xlfSqrtpi |
| 400 | xlfQuotient |
| 401 | xlfDelta |
| 402 | xlfGestep |
| 403 | xlfIseven |
| 404 | xlfIsodd |
| 405 | xlfMround |
| 406 | xlfErf |
| 407 | xlfErfc |
| 408 | xlfBesselj |
| 409 | xlfBesselk |
| 410 | xlfBessely |
| 411 | xlfBesseli |
| 412 | xlfXirr |
| 413 | xlfXnpv |
| 414 | xlfPricemat |
| 415 | xlfYieldmat |
| 416 | xlfIntrate |
| 417 | xlfReceived |
| 418 | xlfDisc |
| 419 | xlfPricedisc |
| 420 | xlfYielddisc |
| 421 | xlfTbilleq |
| 422 | xlfTbillprice |
| 423 | xlfTbillyield |
| 424 | xlfPrice |
| 425 | xlfYield |
| 426 | xlfDollarde |
| 427 | xlfDollarfr |
| 428 | xlfNominal |
| 429 | xlfEffect |
| 430 | xlfCumprinc |
| 431 | xlfCumipmt |
| 432 | xlfEdate |
| 433 | xlfEomonth |
| 434 | xlfYearfrac |
| 435 | xlfCoupdaybs |
| 436 | xlfCoupdays |
| 437 | xlfCoupdaysnc |
| 438 | xlfCoupncd |
| 439 | xlfCoupnum |
| 440 | xlfCouppcd |
| 441 | xlfDuration |
| 442 | xlfMduration |
| 443 | xlfOddlprice |
| 444 | xlfOddlyield |
| 445 | xlfOddfprice |
| 446 | xlfOddfyield |
| 447 | xlfRandbetween |
| 448 | xlfWeeknum |
| 449 | xlfAmordegrc |
| 450 | xlfAmorlinc |
| 451 | xlfConvert |
| 452 | xlfAccrint |
| 453 | xlfAccrintm |
| 454 | xlfWorkday |
| 455 | xlfNetworkdays |
| 456 | xlfGcd |
| 457 | xlfMultinomial |
| 458 | xlfLcm |
| 459 | xlfFvschedule |
| 460 | xlfCubekpimember |
| 461 | xlfCubeset |
| 462 | xlfCubesetcount |
| 463 | xlfIferror |
| 464 | xlfCountifs |
| 465 | xlfSumifs |
| 466 | xlfAverageif |
| 467 | xlfAverageifs |
| 468 | xlfAggregate |
| 469 | xlfBinom_dist |
| 470 | xlfBinom_inv |
| 471 | xlfConfidence_norm |
| 472 | xlfConfidence_t |
| 473 | xlfChisq_test |
| 474 | xlfF_test |
| 475 | xlfCovariance_p |
| 476 | xlfCovariance_s |
| 477 | xlfExpon_dist |
| 478 | xlfGamma_dist |
| 479 | xlfGamma_inv |
| 480 | xlfMode_mult |
| 481 | xlfMode_sngl |
| 482 | xlfNorm_dist |
| 483 | xlfNorm_inv |
| 484 | xlfPercentile_exc |
| 485 | xlfPercentile_inc |
| 486 | xlfPercentrank_exc |
| 487 | xlfPercentrank_inc |
| 488 | xlfPoisson_dist |
| 489 | xlfQuartile_exc |
| 490 | xlfQuartile_inc |
| 491 | xlfRank_avg |
| 492 | xlfRank_eq |
| 493 | xlfStdev_s |
| 494 | xlfStdev_p |
| 495 | xlfT_dist |
| 496 | xlfT_dist_2t |
| 497 | xlfT_dist_rt |
| 498 | xlfT_inv |
| 499 | xlfT_inv_2t |
| 500 | xlfVar_s |
| 501 | xlfVar_p |
| 502 | xlfWeibull_dist |
| 503 | xlfNetworkdays_intl |
| 504 | xlfWorkday_intl |
| 505 | xlfEcma_ceiling |
| 506 | xlfIso_ceiling |
| 507 | xlfBeta_dist |
| 508 | xlfBeta_inv |
| 509 | xlfChisq_dist |
| 510 | xlfChisq_dist_rt |
| 511 | xlfChisq_inv |
| 512 | xlfChisq_inv_rt |
| 513 | xlfF_dist |
| 514 | xlfF_dist_rt |
| 515 | xlfF_inv |
| 516 | xlfF_inv_rt |
| 517 | xlfHypgeom_dist |
| 518 | xlfLognorm_dist |
| 519 | xlfLognorm_inv |
| 520 | xlfNegbinom_dist |
| 521 | xlfNorm_s_dist |
| 522 | xlfNorm_s_inv |
| 523 | xlfT_test |
| 524 | xlfZ_test |
| 525 | xlfErf_precise |
| 526 | xlfErfc_precise |
| 527 | xlfGammaln_precise |
| 528 | xlfCeiling_precise |
| 529 | xlfFloor_precise |
