About the Tutorial - tutorialspoint.com

1 advanced excel Functions About the Tutorial This Microsoft excel Tutorial teaches you how to create and use excel functions. You can use excel functions to perform various mathematical, statistical, logical calculations. This Tutorial takes you step-by-step through the process. Audience This Tutorial is intended for people who use excel but are intimidated by the concept of formulas and functions. Prerequisites This Tutorial assumes your familiarity with basic fomulas for calculations in excel . Copyright & Disclaimer Copyright 2016 by Tutorials Point (I) Pvt. Ltd. All the content and graphics published in this e-book are the property of Tutorials Point (I).

2 Pvt. Ltd. The user of this e-book is prohibited to reuse, retain, copy, distribute or republish any contents or a part of contents of this e-book in any manner without written consent of the publisher. We strive to update the contents of our website and tutorials as timely and as precisely as possible, however, the contents may contain inaccuracies or errors. Tutorials Point (I) Pvt. Ltd. provides no guarantee regarding the accuracy, timeliness or completeness of our website or its contents including this Tutorial . If you discover any errors on our website or in this Tutorial , please notify us at i advanced excel Functions Table of Contents About the Tutorial .

3 I Audience .. i Prerequisites .. i Copyright & Disclaimer .. i Table of Contents .. ii COMPATIBILITY 1. 1. Compatibility Functions Overview .. 2. 2. BETADIST Function .. 5. 3. BETAINV 6. 4. BINOMDIST Function .. 8. 5. CEILING Function .. 10. 6. CHIDIST Function .. 12. 7. CHIINV Function .. 13. 8. CHITEST Function .. 15. 9. CONFIDENCE Function .. 17. 10. COVAR Function .. 19. 11. CRITBINOM Function .. 21. 12. EXPONDIST Function .. 22. 13. FDIST Function .. 24. 14. FINV Function .. 26. 15. FLOOR Function .. 28. 16. FTEST Function .. 30. 17. GAMMADIST Function .. 32. 18. GAMMAINV Function.

4 34. 19. HYPGEOMDIST Function .. 36. 20. LOGINV Function .. 38. 21. LOGNORMDIST Function .. 39. 22. MODE Function .. 40. ii advanced excel Functions 23. NEGBINOMDIST Function .. 42. 24. NORMDIST Function .. 44. 25. NORMINV Function .. 46. 26. NORMSDIST Function .. 48. 27. NORMSINV Function .. 49. 28. PERCENTILE Function .. 50. 29. PERCENTRANK Function .. 51. 30. POISSON Function .. 53. 31. QUARTILE Function .. 55. 32. RANK Function .. 57. 33. STDEV Function .. 59. 34. STDEVP Function .. 61. 35. TDIST 63. 36. TINV Function .. 65. 37. TTEST Function .. 67. 38. VAR Function .. 69. 39.

5 VARP Function .. 71. 40. WEIBULL Function .. 73. 41. ZTEST Function .. 75. CUBE FUNCTIONS .. 77. 42. Cube Functions Overview .. 78. 43. CUBEKPIMEMBER Function .. 79. 44. CUBEMEMBER Function .. 81. 45. CUBEMEMBERPROPERTY Function .. 83. 46. CUBERANKEDMEMBER Function .. 85. 47. CUBESET 87. 48. CUBESETCOUNT Function .. 89. iii advanced excel Functions 49. CUBEVALUE 90. DATABASE FUNCTIONS .. 93. 50. Database Functions 94. 51. DAVERAGE Function .. 96. 52. DCOUNT Function .. 98. 53. DCOUNTA Function .. 100. 54. DGET Function .. 102. 55. DMAX Function .. 104. 56. DMIN Function .. 106. 57.

6 DPRODUCT Function .. 108. 58. DSTDEV Function .. 110. 59. DSTDEVP Function .. 112. 60. DSUM 114. 61. DVAR Function .. 116. 62. DVARP Function .. 118. DATE & TIME FUNCTIONS .. 120. 63. Date & Time Functions Overview .. 121. 64. DATE Function .. 123. 65. DATEDIF Function .. 125. 66. DATEVALUE Function .. 127. 67. DAY Function .. 129. 68. DAYS Function .. 131. 69. DAYS360 Function .. 133. 70. EDATE Function .. 135. 71. EOMONTH Function .. 137. 72. HOUR Function .. 139. 73. ISOWEEKNUM Function .. 140. iv advanced excel Functions 74. MINUTE Function .. 141. 75. MONTH Function .. 142. 76.

7 NETWORKDAYS Function .. 143. 77. Function .. 144. 78. NOW Function .. 147. 79. SECOND Function .. 149. 80. TIME Function .. 151. 81. TIMEVALUE Function .. 153. 82. TODAY Function .. 154. 83. WEEKDAY Function .. 155. 84. WEEKNUM Function .. 157. 85. WORKDAY Function .. 159. 86. Function .. 161. 87. YEAR Function .. 163. 88. YEARFRAC Function .. 164. ENGINEERING FUNCTIONS .. 166. 89. Engineering Functions Overview .. 167. 90. BESSELI Function .. 171. 91. BESSELJ Function .. 172. 92. BESSELK Function .. 173. 93. BESSELY Function .. 174. 94. BIN2 DEC Function .. 175. 95. BIN2 HEX Function.

8 176. 96. BIN2 OCT Function .. 178. 97. BITAND Function .. 180. 98. BITLSHIFT Function .. 182. 99. BITOR Function .. 184. v advanced excel Functions 100. BITRSHIFT 186. 101. BITXOR Function .. 188. 102. COMPLEX FUNCTION .. 190. 103. CONVERT Function .. 192. 104. DEC2 BIN Function .. 198. 105. DEC2 HEX Function .. 200. 106. DEC2 OCT Function .. 202. 107. DELTA Function .. 204. 108. ERF Function .. 206. 109. Function .. 208. 110. ERFC Function .. 209. 111. Function .. 211. 112. GESTEP Function .. 212. 113. HEX2 BIN Function .. 213. 114. HEX2 DEC Function .. 215. 115. HEX2 OCT Function.

9 217. 116. IMABS Function .. 219. 117. IMAGINARY 221. 118. IMARGUMENT Function .. 223. 119. IMCONJUGATE Function .. 224. 120. IMCOS Function .. 225. 121. IMCOSH Function .. 227. 122. IMCOT Function .. 229. 123. IMCSC Function .. 231. 124. IMCSCH Function .. 233. 125. IMDIV 235. 126. IMEXP Function .. 237. 127. IMLN Function .. 239. vi advanced excel Functions 128. IMLOG2 Function .. 241. 129. IMLOG10 Function .. 243. 130. IMPOWER Function .. 245. 131. IMPRODUCT Function .. 247. 132. IMREAL Function .. 249. 133. IMSEC Function .. 251. 134. IMSECH Function .. 253. 135. IMSIN Function.

10 255. 136. MSINH Function .. 257. 137. IMSQRT Function .. 259. 138. IMSUB Function .. 261. 139. IMSUM 263. 140. IMTAN Function .. 265. 141. OCT2 BIN Function .. 267. 142. OCT2 DEC Function .. 269. 143. OCT2 HEX Function .. 270. FINANCIAL FUNCTIONS .. 272. 144. Financial Functions Overview .. 273. 145. ACCRINT Function .. 277. 146. ACCRINTM Function .. 280. 147. AMORDEGRC Function .. 282. 148. AMORLINC Function .. 284. 149. COUPDAYBS Function .. 286. 150. COUPDAYS Function .. 288. 151. COUPDAYSNC Function .. 290. 152. COUPNCD 292. 153. COUPNUM Function .. 294. vii advanced excel Functions 154.