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 IMAGE Function
  223. The IMAGINARY Function
  224. The IMARGUMENT Function
  225. The IMCONJUGATE Function
  226. The IMCOS Function
  227. The IMCOSH Function
  228. The IMCOT Function
  229. The IMCSC Function
  230. The IMCSCH Function
  231. The IMDIV Function
  232. The IMEXP Function
  233. The IMLN Function
  234. The IMLOG10 Function
  235. The IMLOG2 Function
  236. The IMPOWER Function
  237. The IMPRODUCT Function
  238. The IMREAL Function
  239. The IMSEC Function
  240. The IMSECH Function
  241. The IMSIN Function
  242. The IMSINH Function
  243. The IMSQRT Function
  244. The IMSUB Function
  245. The IMSUM Function
  246. The IMTAN Function
  247. The INDEX Function
  248. The INDIRECT Function
  249. The INFO Function
  250. The INT Function
  251. The INTERCEPT Function
  252. The INTRATE Function
  253. The IPMT Function
  254. The IRR Function
  255. The ISBLANK Function
  256. The ISERR Function
  257. The ISERROR Function
  258. The ISEVEN Function
  259. The ISFORMULA Function
  260. The ISLOGICAL Function
  261. The ISNA Function
  262. The ISNONTEXT Function
  263. The ISNUMBER Function
  264. The ISO.CEILING Function
  265. The ISODD Function
  266. The ISOMITTED Function
  267. The ISOWEEKNUM Function
  268. The ISPMT Function
  269. The ISREF Function
  270. The ISTEXT Function
  271. The JIS Function
  272. The KURT Function
  273. The LAMBDA Function
  274. The LARGE Function
  275. The LCM Function
  276. The LEFT Function
  277. The LEFTB Function
  278. The LEN Function
  279. The LENB Function
  280. The LET Function
  281. The LINEST Function
  282. The LN Function
  283. The LOG Function
  284. The LOG10 Function
  285. The LOGEST Function
  286. The LOGINV Function
  287. The LOGNORM.DIST Function
  288. The LOGNORM.INV Function
  289. The LOGNORMDIST Function
  290. The LOOKUP Function
  291. The LOWER Function
  292. The MAKEARRAY Function
  293. The MAP Function
  294. The MATCH Function
  295. The MAX Function
  296. The MAXA Function
  297. The MAXIFS Function
  298. The MDETERM Function
  299. The MDURATION Function
  300. The MEDIAN Function
  301. The MID Function
  302. The MIDB Function
  303. The MIN Function
  304. The MINA Function
  305. The MINIFS Function
  306. The MINUTE Function
  307. The MINVERSE Function
  308. The MIRR Function
  309. The MMULT Function
  310. The MOD Function
  311. The MODE Function
  312. The MODE.MULT Function
  313. The MODE.SNGL Function
  314. The MONTH Function
  315. The MROUND Function
  316. The MULTINOMIAL Function
  317. The MUNIT Function
  318. The N Function
  319. The NA Function
  320. The NEGBINOM.DIST Function
  321. The NEGBINOMDIST Function
  322. the NETWORKDAYS Function
  323. the NETWORKDAYS.INTL Function
  324. the NOMINAL Function
  325. the NORM.DIST Function
  326. the NORM.INV Function
  327. the NORM.S.DIST Function
  328. the NORM.S.INV Function
  329. the NORMDIST Function
  330. the NORMINV Function
  331. the NORMSDIST Function
  332. the NORMSINV Function
  333. the NOT Function
  334. the NOW Function
  335. the NPER Function
  336. the NPV Function
  337. the NUMBERVALUE Function
  338. the OCT2BIN Function

Newsletter