functionlist.txt 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400
  1. ABS
  2. ACCRINT
  3. ACCRINTM
  4. ACOS
  5. ACOSH
  6. ACOT
  7. ACOTH
  8. ADDRESS
  9. AMORDEGRC
  10. AMORLINC
  11. AND
  12. ARABIC
  13. AREAS
  14. ASC
  15. ASIN
  16. ASINH
  17. ATAN
  18. ATAN2
  19. ATANH
  20. AVEDEV
  21. AVERAGE
  22. AVERAGEA
  23. AVERAGEIF
  24. AVERAGEIFS
  25. BAHTTEXT
  26. BASE
  27. BESSELI
  28. BESSELJ
  29. BESSELK
  30. BESSELY
  31. BETADIST
  32. BETAINV
  33. BIN2DEC
  34. BIN2HEX
  35. BIN2OCT
  36. BINOMDIST
  37. BITAND
  38. BITLSHIFT
  39. BITOR
  40. BITRSHIFT
  41. BITXOR
  42. CEILING
  43. CEILING.MATH
  44. CEILING.PRECISE
  45. CELL
  46. CHAR
  47. CHIDIST
  48. CHIINV
  49. CHITEST
  50. CHOOSE
  51. CLEAN
  52. CODE
  53. COLUMN
  54. COLUMNS
  55. COMBIN
  56. COMBINA
  57. COMPLEX
  58. CONCAT
  59. CONCATENATE
  60. CONFIDENCE
  61. CONVERT
  62. CORREL
  63. COS
  64. COSH
  65. COT
  66. COTH
  67. COUNT
  68. COUNTA
  69. COUNTBLANK
  70. COUNTIF
  71. COUNTIFS
  72. COUPDAYBS
  73. COUPDAYBS
  74. COUPDAYSNC
  75. COUPNCD
  76. COUPNUM
  77. COUPPCD
  78. COVAR
  79. CRITBINOM
  80. CSC
  81. CSCH
  82. CUBEKPIMEMBER
  83. CUBEMEMBER
  84. CUBEMEMBERPROPERTY
  85. CUBERANKEDMEMBER
  86. CUBESET
  87. CUBESETCOUNT
  88. CUBEVALUE
  89. CUMIPMT
  90. CUMPRINC
  91. DATE
  92. DATEDIF
  93. DATEVALUE
  94. DAVERAGE
  95. DAY
  96. DAYS
  97. DAYS360
  98. DB
  99. DCOUNT
  100. DCOUNTA
  101. DDB
  102. DEC2BIN
  103. DEC2HEX
  104. DEC2OCT
  105. DEGREES
  106. DELTA
  107. DEVSQ
  108. DGET
  109. DISC
  110. DMAX
  111. DMIN
  112. DOLLAR
  113. DOLLARDE
  114. DOLLARFR
  115. DPRODUCT
  116. DSTDEV
  117. DSTDEVP
  118. DSUM
  119. DURATION
  120. DVAR
  121. DVARP
  122. EDATE
  123. EFFECT
  124. EOMONTH
  125. ERF
  126. ERF.PRECISE
  127. ERFC
  128. ERFC.PRECISE
  129. ERROR.TYPE
  130. EVEN
  131. EXACT
  132. EXP
  133. EXPONDIST
  134. FACT
  135. FACTDOUBLE
  136. FALSE
  137. FDIST
  138. FIND
  139. FINDB
  140. FINV
  141. FISHER
  142. FISHERINV
  143. FIXED
  144. FLOOR
  145. FLOOR.MATH
  146. FLOOR.PRECISE
  147. FORECAST
  148. FREQUENCY
  149. FTEST
  150. FV
  151. FVSCHEDULE
  152. GAMAMDIST
  153. GAMMAINV
  154. GAMMALN
  155. GCD
  156. GEOMEAN
  157. GESTEP
  158. GETPIVOTDATA
  159. GROWTH
  160. HARMEAN
  161. HEX2BIN
  162. HEX2OCT
  163. HLOOKUP
  164. HOUR
  165. HYPERLINK
  166. HYPGEOMDIST
  167. IF
  168. IFERROR
  169. IFS
  170. IMABS
  171. IMAGINARY
  172. IMARGUMENT
  173. IMCONJUGATE
  174. IMCOS
  175. IMCOSH
  176. IMCOT
  177. IMCSC
  178. IMCSCH
  179. IMEXP
  180. IMLN
  181. IMLOG10
  182. IMLOG2
  183. IMPOWER
  184. IMPRODUCT
  185. IMREAL
  186. IMSEC
  187. IMSECH
  188. IMSIN
  189. IMSINH
  190. IMSQRT
  191. IMSUB
  192. IMSUM
  193. IMTAN
  194. INDEX
  195. INDIRECT
  196. INFO
  197. INT
  198. INTERCEPT
  199. INTRATE
  200. IPMT
  201. IRR
  202. ISBLANK
  203. ISERR
  204. ISERROR
  205. ISEVEN
  206. ISLOGICAL
  207. ISNA
  208. ISNONTEXT
  209. ISNUMBER
  210. ISODD
  211. ISOWEEKNUM
  212. ISPMT
  213. ISREF
  214. ISTEXT
  215. JIS
  216. KURT
  217. LARGE
  218. LCM
  219. LEFT
  220. LEFTB
  221. LEN
  222. LENB
  223. LINEST
  224. LN
  225. LOG
  226. LOG10
  227. LOGEST
  228. LOGINV
  229. LOGNORMDIST
  230. LOOKUP
  231. LOWER
  232. MATCH
  233. MAX
  234. MAXA
  235. MAXIFS
  236. MDETERM
  237. MDURATION
  238. MEDIAN
  239. MID
  240. MIDB
  241. MIN
  242. MINA
  243. MINIFS
  244. MINUTE
  245. MINVERSE
  246. MIRR
  247. MMULT
  248. MOD
  249. MODE
  250. MONTH
  251. MROUND
  252. MULTINOMIAL
  253. MUNIT
  254. N
  255. NA
  256. NEGBINOMDIST
  257. NETWORKDAYS
  258. NOMINAL
  259. NORMDIST
  260. NORMINV
  261. NORMSDIST
  262. NORMSINV
  263. NOT
  264. NOW
  265. NPER
  266. NPV
  267. NUMBERVALUE
  268. OCT2BIN
  269. OCT2DEC
  270. OCT2HEX
  271. ODD
  272. ODDFPRICE
  273. ODDFYIELD
  274. ODDLPRICE
  275. ODDLYIELD
  276. OFFSET
  277. OR
  278. PDURATION
  279. PEARSON
  280. PERCENTILE
  281. PERCENTRANK
  282. PERMUT
  283. PERMUTATIONA
  284. PHONETIC
  285. PI
  286. PMT
  287. POISSON
  288. POWER
  289. PPMT
  290. PRICE
  291. PRICEDISC
  292. PRICEMAT
  293. PROB
  294. PRODUCT
  295. PROPER
  296. PV
  297. QUARTILE
  298. QUOTIENT
  299. RADIANS
  300. RAND
  301. RANDBETWEEN
  302. RANK
  303. RATE
  304. RECEIVED
  305. REPLACE
  306. REPLACEB
  307. REPT
  308. RIGHT
  309. RIGHTB
  310. ROMAN
  311. ROUND
  312. ROUNDDOWN
  313. ROUNDUP
  314. ROW
  315. ROWS
  316. RRI
  317. RSQ
  318. RTD
  319. SEARCH
  320. SEARCHB
  321. SEC
  322. SECH
  323. SECOND
  324. SERIESSUM
  325. SHEET
  326. SHEETS
  327. SIGN
  328. SIN
  329. SINH
  330. SKEW
  331. SLN
  332. SLOPE
  333. SMALL
  334. SQRT
  335. SQRTPI
  336. STANDARDIZE
  337. STDEV
  338. STDEV.A
  339. STDEV.P
  340. STDEVA
  341. STDEVP
  342. STDEVPA
  343. STEYX
  344. SUBSTITUTE
  345. SUBTOTAL
  346. SUM
  347. SUMIF
  348. SUMIFS
  349. SUMPRODUCT
  350. SUMSQ
  351. SUMX2MY2
  352. SUMX2PY2
  353. SUMXMY2
  354. SWITCH
  355. SYD
  356. T
  357. TAN
  358. TANH
  359. TBILLEQ
  360. TBILLPRICE
  361. TBILLYIELD
  362. TDIST
  363. TEXT
  364. TEXTJOIN
  365. TIME
  366. TIMEVALUE
  367. TINV
  368. TODAY
  369. TRANSPOSE
  370. TREND
  371. TRIM
  372. TRIMMEAN
  373. TRUE
  374. TRUNC
  375. TTEST
  376. TYPE
  377. UNICHAR
  378. UNIORD
  379. UPPER
  380. USDOLLAR
  381. VALUE
  382. VAR
  383. VARA
  384. VARP
  385. VARPA
  386. VDB
  387. VLOOKUP
  388. WEEKDAY
  389. WEEKNUM
  390. WEIBULL
  391. WORKDAY
  392. XIRR
  393. XNPV
  394. XOR
  395. YEAR
  396. YEARFRAC
  397. YIELD
  398. YIELDDISC
  399. YIELDMAT
  400. ZTEST