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 DATEVALUE Function
  115. The DAVERAGE Function
  116. The DAY Function
  117. The DAYS Function
  118. The DAYS360 Function
  119. The DB Function
  120. The DBCS Function
  121. The DCOUNT Function
  122. The DCOUNTA Function
  123. The DDB Function
  124. The DEC2BIN Function
  125. The DEC2HEX Function
  126. The DEC2OCT Function
  127. The DECIMAL Function
  128. The DEGREES Function
  129. The DELTA Function
  130. The DEVSQ Function
  131. The DGET Function
  132. The DISC Function
  133. The DMAX Function
  134. The DMIN Function
  135. The DOLLAR Function
  136. The DOLLARDE Function
  137. The DOLLARFR Function
  138. The DPRODUCT Function
  139. The DROP Function
  140. The DSTDEV Function
  141. The DSTDEVP Function
  142. The DSUM Function
  143. The DURATION Function
  144. The DVAR Function
  145. The DVARP Function
  146. The EDATE Function
  147. The EFFECT Function
  148. The ENCODEURL Function
  149. The EOMONTH Function
  150. The ERF Function
  151. The ERF.PRECISE Function
  152. The ERFC Function
  153. The ERFC.PRECISE Function
  154. The ERROR.TYPE Function
  155. The EUROCONVERT Function
  156. The EVEN Function
  157. The EXACT Function
  158. The EXP Function
  159. The EXPAND Function
  160. The EXPON.DIST Function
  161. The EXPONDIST Function
  162. The F.DIST Function
  163. The F.DIST.RT Function
  164. The F.INV Function
  165. The F.INV.RT Function
  166. The F.TEST Function
  167. The FACT Function
  168. The FACTDOUBLE Function
  169. The FALSE Function
  170. The FDIST Function
  171. The FIELDVALUE Function
  172. The FILTER Function
  173. The FILTERXML Function
  174. The FIND Function
  175. The FINDB Function
  176. The FINV Function
  177. The FISHER Function
  178. The FISHERINV Function
  179. The FIXED Function
  180. The FLOOR Function
  181. The FLOOR.MATH Function
  182. The FLOOR.PRECISE Function
  183. The FORECAST Function
  184. The FORECAST.ETS Function
  185. The FORECAST.ETS.CONFINT Function
  186. The FORECAST.ETS.SEASONALITY Function
  187. The FORECAST.ETS.STAT Function
  188. The FORECAST.LINEAR Function
  189. The FORMULATEXT Function
  190. The FREQUENCY Function
  191. The FTEST Function
  192. The FV Function
  193. The FVSCHEDULE Function
  194. The GAMMA Function
  195. The GAMMA.DIST Function
  196. The GAMMA.INV Function
  197. The GAMMADIST Function
  198. The GAMMAINV Function
  199. The GAMMALN Function
  200. The GAMMALN.PRECISE Function
  201. The GAUSS Function
  202. The GCD Function
  203. The GEOMEAN Function
  204. The GESTEP Function
  205. The GETPIVOTDATA Function
  206. The GROWTH Function
  207. The HARMEAN Function
  208. The HEX2BIN Function
  209. The HEX2DEC Function
  210. The HEX2OCT Function
  211. The HLOOKUP Function
  212. The HOUR Function
  213. The HSTACK Function
  214. The HYPERLINK Function
  215. The HYPGEOM.DIST Function
  216. The HYPGEOMDIST Function
  217. The IF Function
  218. The IFERROR Function
  219. The IFNA Function
  220. The IFS Function
  221. The IMABS Function
  222. The IMAGINARY Function
  223. The IMARGUMENT Function
  224. The IMCONJUGATE Function
  225. The IMCOS Function
  226. The IMCOSH Function
  227. The IMCOT Function
  228. The IMCSC Function
  229. The IMCSCH Function
  230. The IMDIV Function
  231. The IMEXP Function
  232. The IMLN Function
  233. The IMLOG10 Function
  234. The IMLOG2 Function
  235. The IMPOWER Function
  236. The IMPRODUCT Function
  237. The IMREAL Function
  238. The IMSEC Function
  239. The IMSECH Function
  240. The IMSIN Function
  241. The IMSINH Function
  242. The IMSQRT Function
  243. The IMSUB Function
  244. The IMSUM Function
  245. The IMTAN Function
  246. The INDEX Function
  247. The INDIRECT Function
  248. The INFO Function
  249. The INT Function
  250. The INTERCEPT Function
  251. The INTRATE Function
  252. The IPMT Function
  253. The IRR Function
  254. The ISBLANK Function
  255. The ISERR Function
  256. The ISERROR Function
  257. The ISEVEN Function
  258. The ISFORMULA Function
  259. The ISLOGICAL Function
  260. The ISNA Function
  261. The ISNONTEXT Function
  262. The ISNUMBER Function
  263. The ISO.CEILING Function
  264. The ISODD Function
  265. The ISOMITTED Function
  266. The ISOWEEKNUM Function
  267. The ISPMT Function
  268. The ISREF Function
  269. The ISTEXT Function
  270. The JIS Function
  271. The KURT Function
  272. The LAMBDA Function
  273. The LARGE Function
  274. The LCM Function
  275. The LEFT Function
  276. The LEFTB Function
  277. The LEN Function
  278. The LENB Function
  279. The LET Function
  280. The LINEST Function
  281. The LN Function
  282. The LOG Function
  283. The LOG10 Function
  284. The LOGEST Function
  285. The LOGINV Function
  286. The LOGNORM.DIST Function
  287. The LOGNORM.INV Function
  288. The LOGNORMDIST Function
  289. The LOOKUP Function
  290. The LOWER Function
  291. The MAKEARRAY Function
  292. The MAP Function
  293. The MATCH Function
  294. The MAX Function
  295. The MAXA Function
  296. The MAXIFS Function
  297. The MDETERM Function
  298. The MDURATION Function
  299. The MEDIAN Function
  300. The MID Function
  301. The MIDB Function
  302. The MIN Function
  303. The MINA Function
  304. The MINIFS Function
  305. The MINUTE Function
  306. The MINVERSE Function
  307. The MIRR Function

Newsletter