functionlist.txt 2.5 KB

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