Please note javascript is required for full website functionality.

A to Z of Excel Functions

A to Z of Excel Functions

Here is a complete list and respective links to all of our A to Z of Excel function blogs:  

  1. The ABS Function
  2. The ACCRINT Function
  3. The ACCRINTM Function
  4. The ACOS Function
  5. The ACOSH Function
  6. The ACOT Function
  7. The ACOTH Function
  8. The ADDRESS Function
  9. The AGGREGATE Function
  10. The AMORDEGRC Function
  11. The AMORLINC Function
  12. The AND Function
  13. The ARABIC Function
  14. The AREAS Function
  15. The ARRAYTOTEXT Function
  16. The ASC Function
  17. The ASIN Function
  18. The ASINH Function
  19. The ATAN Function
  20. The ATAN2 Function
  21. The ATANH Function
  22. The AVEDEV Function
  23. The AVERAGE Function
  24. The AVERAGEA Function
  25. The AVERAGEIF Function
  26. The AVERAGEIFS Function
  27. The BAHTTEXT Function
  28. The BASE Function
  29. The BESSELI Function
  30. The BESSELJ Function
  31. The BESSELK Function
  32. The BESSELY Function
  33. The BETA.DIST Function
  34. The BETA.INV Function
  35. The BETADIST Function
  36. The BETAINV Function
  37. The BIN2DEC Function
  38. The BIN2HEX Function
  39. The BIN2OCT Function
  40. The BINOM.DIST Function
  41. The BINOM.DIST.RANGE Function
  42. The BINOM.INV Function
  43. The BINOMDIST Function
  44. The BITAND Function
  45. The BITLSHIFT Function
  46. The BITOR Function
  47. The BITRSHIFT Function
  48. The BITXOR Function
  49. The BYCOL Function
  50. The BYROW Function
  51. The CALL Function
  52. The CEILING Function
  53. The CEILING.MATH Function
  54. The CEILING.PRECISE Function
  55. The CELL Function
  56. The CHAR Function
  57. The CHIDIST Function
  58. The CHIINV Function
  59. The CHISQ.DIST Function
  60. The CHISQ.DIST.RT Function
  61. The CHISQ.INV Function
  62. The CHISQ.INV.RT Function
  63. The CHISQ.TEST Function
  64. The CHITEST Function
  65. The CHOOSE Function
  66. The CHOOSECOLS Function
  67. The CHOOSEROWS Function
  68. The CLEAN Function
  69. The CODE Function
  70. The COLUMN Function
  71. The COLUMNS Function
  72. The COMBIN Function
  73. The COMBINA Function
  74. The COMPLEX Function
  75. The CONCAT Function
  76. The CONCATENATE Function
  77. The CONFIDENCE Function
  78. The CONFIDENCE.NORM Function
  79. The CONFIDENCE.T Function
  80. The CONVERT Function
  81. The CORREL Function
  82. The CORVARIANCE.P Function
  83. The CORVARIANCE.S Function
  84. The COS Function
  85. The COSH Function
  86. The COT Function
  87. The COTH Function
  88. The COUNT Function
  89. The COUNTA Function
  90. The COUNTBLANK Function
  91. The COUNTIF Function
  92. The COUNTIFS Function
  93. The COUPDAYBS Function
  94. The COUPDAYS Function
  95. The COUPDAYSNC Function
  96. The COUPNCD Function
  97. The COUPNUM Function
  98. The COUPPCD Function
  99. The COVAR Function
  100. The CRITBINOM Function
  101. The CSC Function
  102. The CSCH Function
  103. The CUBEKPIMEMBER Function
  104. The CUBEMEMBER Function
  105. The CUBEMEMBERPROPERTY Function
  106. The CUBERANKEDMEMBER Function
  107. The CUBESET Function
  108. The CUBESETCOUNT Function
  109. The CUBEVALUE Function
  110. The CUMIPMT Function
  111. The CUMPRINC Function
  112. The DATE Function
  113. The DATEDIF Function
  114. The DATESTRING Function
  115. The DATEVALUE Function
  116. The DAVERAGE Function
  117. The DAY Function
  118. The DAYS Function
  119. The DAYS360 Function
  120. The DB Function
  121. The DBCS Function
  122. The DCOUNT Function
  123. The DCOUNTA Function
  124. The DDB Function
  125. The DEC2BIN Function
  126. The DEC2HEX Function
  127. The DEC2OCT Function
  128. The DECIMAL Function
  129. The DEGREES Function
  130. The DELTA Function
  131. The DEVSQ Function
  132. The DGET Function
  133. The DISC Function
  134. The DMAX Function
  135. The DMIN Function
  136. The DOLLAR Function
  137. The DOLLARDE Function
  138. The DOLLARFR Function
  139. The DPRODUCT Function
  140. The DROP Function
  141. The DSTDEV Function
  142. The DSTDEVP Function
  143. The DSUM Function
  144. The DURATION Function
  145. The DVAR Function
  146. The DVARP Function
  147. The ECMA.CEILING Function
  148. The EDATE Function
  149. The EFFECT Function
  150. The ENCODEURL Function
  151. The EOMONTH Function
  152. The ERF Function
  153. The ERF.PRECISE Function
  154. The ERFC Function
  155. The ERFC.PRECISE Function
  156. The ERROR.TYPE Function
  157. The EUROCONVERT Function
  158. The EVEN Function
  159. The EXACT Function
  160. The EXP Function
  161. The EXPAND Function
  162. The EXPON.DIST Function
  163. The EXPONDIST Function
  164. The F.DIST Function
  165. The F.DIST.RT Function
  166. The F.INV Function
  167. The F.INV.RT Function
  168. The F.TEST Function
  169. The FACT Function
  170. The FACTDOUBLE Function
  171. The FALSE Function
  172. The FDIST Function
  173. The FIELDVALUE Function
  174. The FILTER Function
  175. The FILTERXML Function
  176. The FIND Function
  177. The FINDB Function
  178. The FINV Function
  179. The FISHER Function
  180. The FISHERINV Function
  181. The FIXED Function
  182. The FLOOR Function
  183. The FLOOR.MATH Function
  184. The FLOOR.PRECISE Function
  185. The FORECAST Function
  186. The FORECAST.ETS Function
  187. The FORECAST.ETS.CONFINT Function
  188. The FORECAST.ETS.SEASONALITY Function
  189. The FORECAST.ETS.STAT Function
  190. The FORECAST.LINEAR Function
  191. The FORMULATEXT Function
  192. The FREQUENCY Function
  193. The FTEST Function
  194. The FV Function
  195. The FVSCHEDULE Function
  196. The GAMMA Function
  197. The GAMMA.DIST Function
  198. The GAMMA.INV Function
  199. The GAMMADIST Function
  200. The GAMMAINV Function
  201. The GAMMALN Function
  202. The GAMMALN.PRECISE Function
  203. The GAUSS Function
  204. The GCD Function
  205. The GEOMEAN Function
  206. The GESTEP Function
  207. The GETPIVOTDATA Function
  208. The GROUPBY Function
  209. The GROWTH Function
  210. The HARMEAN Function
  211. The HEX2BIN Function
  212. The HEX2DEC Function
  213. The HEX2OCT Function
  214. The HLOOKUP Function
  215. The HOUR Function
  216. The HSTACK Function
  217. The HYPERLINK Function
  218. The HYPGEOM.DIST Function
  219. The HYPGEOMDIST Function
  220. The IF Function
  221. The IFERROR Function
  222. The IFNA Function
  223. The IFS Function
  224. The IMABS Function
  225. The IMAGE Function
  226. The IMAGINARY Function
  227. The IMARGUMENT Function
  228. The IMCONJUGATE Function
  229. The IMCOS Function
  230. The IMCOSH Function
  231. The IMCOT Function
  232. The IMCSC Function
  233. The IMCSCH Function
  234. The IMDIV Function
  235. The IMEXP Function
  236. The IMLN Function
  237. The IMLOG10 Function
  238. The IMLOG2 Function
  239. The IMPOWER Function
  240. The IMPRODUCT Function
  241. The IMREAL Function
  242. The IMSEC Function
  243. The IMSECH Function
  244. The IMSIN Function
  245. The IMSINH Function
  246. The IMSQRT Function
  247. The IMSUB Function
  248. The IMSUM Function
  249. The IMTAN Function
  250. The INDEX Function
  251. The INDIRECT Function
  252. The INFO Function
  253. The INT Function
  254. The INTERCEPT Function
  255. The INTRATE Function
  256. The IPMT Function
  257. The IRR Function
  258. The ISBLANK Function
  259. The ISERR Function
  260. The ISERROR Function
  261. The ISEVEN Function
  262. The ISFORMULA Function
  263. The ISLOGICAL Function
  264. The ISNA Function
  265. The ISNONTEXT Function
  266. The ISNUMBER Function
  267. The ISO.CEILING Function
  268. The ISODD Function
  269. The ISOMITTED Function
  270. The ISOWEEKNUM Function
  271. The ISPMT Function
  272. The ISREF Function
  273. The ISTEXT Function
  274. The JIS Function
  275. The KURT Function
  276. The LAMBDA Function
  277. The LARGE Function
  278. The LCM Function
  279. The LEFT Function
  280. The LEFTB Function
  281. The LEN Function
  282. The LENB Function
  283. The LET Function
  284. The LINEST Function
  285. The LN Function
  286. The LOG Function
  287. The LOG10 Function
  288. The LOGEST Function
  289. The LOGINV Function
  290. The LOGNORM.DIST Function
  291. The LOGNORM.INV Function
  292. The LOGNORMDIST Function
  293. The LOOKUP Function
  294. The LOWER Function
  295. The MAKEARRAY Function
  296. The MAP Function
  297. The MATCH Function
  298. The MAX Function
  299. The MAXA Function
  300. The MAXIFS Function
  301. The MDETERM Function
  302. The MDURATION Function
  303. The MEDIAN Function
  304. The MID Function
  305. The MIDB Function
  306. The MIN Function
  307. The MINA Function
  308. The MINIFS Function
  309. The MINUTE Function
  310. The MINVERSE Function
  311. The MIRR Function
  312. The MMULT Function
  313. The MOD Function
  314. The MODE Function
  315. The MODE.MULT Function
  316. The MODE.SNGL Function
  317. The MONTH Function
  318. The MROUND Function
  319. The MULTINOMIAL Function
  320. The MUNIT Function
  321. The N Function
  322. The NA Function
  323. The NEGBINOM.DIST Function
  324. The NEGBINOMDIST Function
  325. The NETWORKDAYS Function
  326. The NETWORKDAYS.INTL Function
  327. The NOMINAL Function
  328. The NORM.DIST Function
  329. The NORM.INV Function
  330. The NORM.S.DIST Function
  331. The NORM.S.INV Function
  332. The NORMDIST Function
  333. The NORMINV Function
  334. The NORMSDIST Function
  335. The NORMSINV Function
  336. The NOT Function
  337. The NOW Function
  338. The NPER Function
  339. The NPV Function
  340. The NUMBERSTRING Function
  341. The NUMBERVALUE Function
  342. The OCT2BIN Function
  343. The OCT2DEC Function
  344. The OCT2HEX Function
  345. The ODD Function
  346. The ODDFPRICE Function
  347. The ODDFYIELD Function
  348. The ODDLPRICE Function
  349. The ODDLYIELD Function
  350. The OFFSET Function
  351. The OR Function
  352. The PDURATION Function
  353. The PEARSON Function
  354. The PERCENTILE Function
  355. The PERCENTILE.EXC Function
  356. The PERCENTILE.INC Function
  357. The PERCENTOF Function
  358. The PERCENTRANK Function
  359. The PERCENTRANK.EXC Function
  360. The PERCENTRANK.INC Function
  361. The PERMUT Function
  362. The PERMUTATIONA Function
  363. The PHI Function
  364. The PHONETIC Function
  365. The PI Function
  366. The PIVOTBY Function
  367. The PMT Function
  368. The POISSON Function
  369. The POISSON.DIST Function
  370. The POWER Function
  371. The PPMT Function
  372. The PRICE Function
  373. The PRICEDISC Function
  374. The PRICEMAT Function
  375. The PROB Function
  376. The PRODUCT Function
  377. The PROPER Function
  378. The PV Function
  379. The PY Function
  380. The QUARTILE Function
  381. The QUARTILE.EXC Function

Newsletter