functionlist.txt 2.7 KB

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