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 DETECTLANGUAGE Function
  132. The DEVSQ Function
  133. The DGET Function
  134. The DISC Function
  135. The DMAX Function
  136. The DMIN Function
  137. The DOLLAR Function
  138. The DOLLARDE Function
  139. The DOLLARFR Function
  140. The DPRODUCT Function
  141. The DROP Function
  142. The DSTDEV Function
  143. The DSTDEVP Function
  144. The DSUM Function
  145. The DURATION Function
  146. The DVAR Function
  147. The DVARP Function
  148. The ECMA.CEILING Function
  149. The EDATE Function
  150. The EFFECT Function
  151. The ENCODEURL Function
  152. The EOMONTH Function
  153. The ERF Function
  154. The ERF.PRECISE Function
  155. The ERFC Function
  156. The ERFC.PRECISE Function
  157. The ERROR.TYPE Function
  158. The EUROCONVERT Function
  159. The EVEN Function
  160. The EXACT Function
  161. The EXP Function
  162. The EXPAND Function
  163. The EXPON.DIST Function
  164. The EXPONDIST Function
  165. The F.DIST Function
  166. The F.DIST.RT Function
  167. The F.INV Function
  168. The F.INV.RT Function
  169. The F.TEST Function
  170. The FACT Function
  171. The FACTDOUBLE Function
  172. The FALSE Function
  173. The FDIST Function
  174. The FIELDVALUE Function
  175. The FILTER Function
  176. The FILTERXML Function
  177. The FIND Function
  178. The FINDB Function
  179. The FINV Function
  180. The FISHER Function
  181. The FISHERINV Function
  182. The FIXED Function
  183. The FLOOR Function
  184. The FLOOR.MATH Function
  185. The FLOOR.PRECISE Function
  186. The FORECAST Function
  187. The FORECAST.ETS Function
  188. The FORECAST.ETS.CONFINT Function
  189. The FORECAST.ETS.SEASONALITY Function
  190. The FORECAST.ETS.STAT Function
  191. The FORECAST.LINEAR Function
  192. The FORMULATEXT Function
  193. The FREQUENCY Function
  194. The FTEST Function
  195. The FV Function
  196. The FVSCHEDULE Function
  197. The GAMMA Function
  198. The GAMMA.DIST Function
  199. The GAMMA.INV Function
  200. The GAMMADIST Function
  201. The GAMMAINV Function
  202. The GAMMALN Function
  203. The GAMMALN.PRECISE Function
  204. The GAUSS Function
  205. The GCD Function
  206. The GEOMEAN Function
  207. The GESTEP Function
  208. The GETPIVOTDATA Function
  209. The GROUPBY Function
  210. The GROWTH Function
  211. The HARMEAN Function
  212. The HEX2BIN Function
  213. The HEX2DEC Function
  214. The HEX2OCT Function
  215. The HLOOKUP Function
  216. The HOUR Function
  217. The HSTACK Function
  218. The HYPERLINK Function
  219. The HYPGEOM.DIST Function
  220. The HYPGEOMDIST Function
  221. The IF Function
  222. The IFERROR Function
  223. The IFNA Function
  224. The IFS Function
  225. The IMABS Function
  226. The IMAGE Function
  227. The IMAGINARY Function
  228. The IMARGUMENT Function
  229. The IMCONJUGATE Function
  230. The IMCOS Function
  231. The IMCOSH Function
  232. The IMCOT Function
  233. The IMCSC Function
  234. The IMCSCH Function
  235. The IMDIV Function
  236. The IMEXP Function
  237. The IMLN Function
  238. The IMLOG10 Function
  239. The IMLOG2 Function
  240. The IMPOWER Function
  241. The IMPRODUCT Function
  242. The IMREAL Function
  243. The IMSEC Function
  244. The IMSECH Function
  245. The IMSIN Function
  246. The IMSINH Function
  247. The IMSQRT Function
  248. The IMSUB Function
  249. The IMSUM Function
  250. The IMTAN Function
  251. The INDEX Function
  252. The INDIRECT Function
  253. The INFO Function
  254. The INT Function
  255. The INTERCEPT Function
  256. The INTRATE Function
  257. The IPMT Function
  258. The IRR Function
  259. The ISBLANK Function
  260. The ISERR Function
  261. The ISERROR Function
  262. The ISEVEN Function
  263. The ISFORMULA Function
  264. The ISLOGICAL Function
  265. The ISNA Function
  266. The ISNONTEXT Function
  267. The ISNUMBER Function
  268. The ISO.CEILING Function
  269. The ISODD Function
  270. The ISOMITTED Function
  271. The ISOWEEKNUM Function
  272. The ISPMT Function
  273. The ISREF Function
  274. The ISTEXT Function
  275. The JIS Function
  276. The KURT Function
  277. The LAMBDA Function
  278. The LARGE Function
  279. The LCM Function
  280. The LEFT Function
  281. The LEFTB Function
  282. The LEN Function
  283. The LENB Function
  284. The LET Function
  285. The LINEST Function
  286. The LN Function
  287. The LOG Function
  288. The LOG10 Function
  289. The LOGEST Function
  290. The LOGINV Function
  291. The LOGNORM.DIST Function
  292. The LOGNORM.INV Function
  293. The LOGNORMDIST Function
  294. The LOOKUP Function
  295. The LOWER Function
  296. The MAKEARRAY Function
  297. The MAP Function
  298. The MATCH Function
  299. The MAX Function
  300. The MAXA Function
  301. The MAXIFS Function
  302. The MDETERM Function
  303. The MDURATION Function
  304. The MEDIAN Function
  305. The MID Function
  306. The MIDB Function
  307. The MIN Function
  308. The MINA Function
  309. The MINIFS Function
  310. The MINUTE Function
  311. The MINVERSE Function
  312. The MIRR Function
  313. The MMULT Function
  314. The MOD Function
  315. The MODE Function
  316. The MODE.MULT Function
  317. The MODE.SNGL Function
  318. The MONTH Function
  319. The MROUND Function
  320. The MULTINOMIAL Function
  321. The MUNIT Function
  322. The N Function
  323. The NA Function
  324. The NEGBINOM.DIST Function
  325. The NEGBINOMDIST Function
  326. The NETWORKDAYS Function
  327. The NETWORKDAYS.INTL Function
  328. The NOMINAL Function
  329. The NORM.DIST Function
  330. The NORM.INV Function
  331. The NORM.S.DIST Function
  332. The NORM.S.INV Function
  333. The NORMDIST Function
  334. The NORMINV Function
  335. The NORMSDIST Function
  336. The NORMSINV Function
  337. The NOT Function
  338. The NOW Function
  339. The NPER Function
  340. The NPV Function
  341. The NUMBERSTRING Function
  342. The NUMBERVALUE Function
  343. The OCT2BIN Function
  344. The OCT2DEC Function
  345. The OCT2HEX Function
  346. The ODD Function
  347. The ODDFPRICE Function
  348. The ODDFYIELD Function
  349. The ODDLPRICE Function
  350. The ODDLYIELD Function
  351. The OFFSET Function
  352. The OR Function
  353. The PDURATION Function
  354. The PEARSON Function
  355. The PERCENTILE Function
  356. The PERCENTILE.EXC Function
  357. The PERCENTILE.INC Function
  358. The PERCENTOF Function
  359. The PERCENTRANK Function
  360. The PERCENTRANK.EXC Function
  361. The PERCENTRANK.INC Function
  362. The PERMUT Function
  363. The PERMUTATIONA Function
  364. The PHI Function
  365. The PHONETIC Function
  366. The PI Function
  367. The PIVOTBY Function
  368. The PMT Function
  369. The POISSON Function
  370. The POISSON.DIST Function
  371. The POWER Function
  372. The PPMT Function
  373. The PRICE Function
  374. The PRICEDISC Function
  375. The PRICEMAT Function
  376. The PROB Function
  377. The PRODUCT Function
  378. The PROPER Function
  379. The PV Function
  380. The PY Function
  381. The QUARTILE Function
  382. The QUARTILE.EXC Function
  383. The QUARTILE.INC Function
  384. The QUOTIENT Function
  385. The RADIANS Function
  386. The RAND Function
  387. The RANDARRAY function
  388. The RANDBETWEEN Function
  389. The RANK Function
  390. The RANK.AVG Function
  391. The RANK.EQ Function
  392. The RATE Function
  393. The RECEIVED Function
  394. The REDUCE Function
  395. The REGEXEXTRACT function
  396. The REGEXREPLACE Function
  397. The REGEXTEST Function
  398. The REGISTER Function
  399. The REGISTER.ID Function
  400. The REPLACE Function
  401. The REPLACEB Function
  402. The REPT Function
  403. The RIGHT Function
  404. The RIGHTB Function

Newsletter