445 Simple & Complicated Calculation Functions in Microsoft Excel 2016

Advertisement

Being a student friendly software company, Redmond-based Microsoft Inc. has always been of help to the students. In Office Excel, the World reknowned software, Microsoft has provided the best and highly complicated calculating functions, related to mathematical, statistical & other scientific functions. By this action, the students are equipped to solve the highly complex scientific, financial and social sciences problems with the help of the hundreds of functions.

Starting from the simple to the highly technical functions, there are 14 sets of formulas and functions which can be applied in the Excel worksheets to achieve marvelous results and findings of the studies.

We have tried to explore the list of the functions which can be worked upon in the Excel worksheet, with the help of the step by step tutorial.


Advertisement


Tutorial

1: Press / Click the ‘AutoSum’ button in the top-right command ribbon of the Microsoft Excel 2016. It will open up a popup menu.2: In the popup menu, see; there are 5 following items:

  1. Sum
  2. Average
  3. Count Numbers
  4. Max
  5. Min
  6. More Functions ….

3: In the popup menu, press / click ‘More Functions …’. It will open up a prompt, named; ‘Insert Function’.4: In the prompt, press / click ‘Or select a category’ to open up a popup of the long list 14 following sets of functions:

  1. All
  2. Financial
  3. Date & Time
  4. Math & Trig
  5. Statistical
  6. Lookup & Reference
  7. Database
  8. Text
  9. Logical
  10. Information
  11. Engineering
  12. Cube
  13. Compatibility
  14. Web

5: To see a complete list of all the calculation functions in all the sets, press / click ‘All’ in the popup. Or scroll down to see all the calculating function in the section ‘Select a function:’. Here, are 154 total functions which are available in this popup which can be applied to work with different types of calculations and other functions.   A Complete List of All Functions, Available in Excel 2016

  1. ABS
  2. ACCPRINT
  3. ACCPRINTM
  4. ACOS
  5. ACOSH
  6. ACOT
  7. ACOTH
  8. ADDRESS
  9. AGGREGATE
  10. AMORDEGRC
  11. AMORLINC
  12. AND
  13. ARABIC
  14. AREAS
  15. ASIN
  16. ASIMH
  17. ASTAN
  18. ATAN2
  19. ATANH
  20. AVEDEV
  21. AVERAGE
  22. AVERAGEA
  23. AVERAGEIF
  24. BATHTEXT
  25. BASE
  26. BESSELI
  27. BESSEU
  28. BESSLK
  29. BESSELY
  30. DIST
  31. INT
  32. BETADIST
  33. BETAINV
  34. BIN2HEC
  35. BINHEX
  36. BIN2OCT
  37. DIST
  38. DIST.RANGE
  39. BINOMDIST
  40. BITAND
  41. BITLSHIFT
  42. BITOR
  43. BITSHIFT
  44. BITXOR
  45. CEILING
  46. MATH
  47. CELL
  48. CHAR
  49. CHIDIST
  50. CHINV
  51. DIST
  52. DIST.TR
  53. INV
  54. INV.RT
  55. TEST
  56. CHITEST
  57. CHOOSE
  58. CLEAN
  59. CODE
  60. COLUMN
  61. COLUMNS
  62. COMBIN
  63. COMBINA
  64. COMPLEX
  65. CONCATENATE
  66. CONFIDENCE
  67. NORM
  68. T
  69. CONVERT
  70. CORREL
  71. COS
  72. COSH
  73. COT
  74. COTH
  75. COUNT
  76. COUNTA
  77. COUNTBLANK
  78. COUNTIF
  79. COUNTIFS
  80. COUNTDAYBS
  81. COUPDAYS
  82. COUPDAYSYNC
  83. COUPNCD
  84. COUPNUM
  85. COUPPCD
  86. COVAR
  87. P
  88. S
  89. CRITBINOM
  90. CSC
  91. CUBEKPIMEMBER
  92. CUBEMEMBER
  93. CUBEMEMBERRPPERTY
  94. CUBERANKEDMEMBER
  95. CUBESET
  96. CUBESETCOUNT
  97. CUBEVALUE
  98. CUMPPMT
  99. CUMPRINC
  100. DATE
  101. DATEVALUE
  102. DAVERAGE
  103. DAYS
  104. DAYS360
  105. DB
  106. DCOUNT
  107. DCOUNTA
  108. DDB
  109. DEC2BIN
  110. DEC2HEX
  111. DEC2OCT
  112. DECIMAL
  113. DEGREES
  114. DELTA
  115. DEVSQ
  116. DGET
  117. DISC
  118. DMAX
  119. DMIN
  120. DOLLAR
  121. DOLLARDE
  122. DOLLARFR
  123. DRPRODUCT
  124. DSTDEV
  125. DSTDEVP
  126. DSUM
  127. DURATION
  128. DVAR
  129. DVARP
  130. EDATE
  131. EFFECT
  132. ENFECT
  133. ENCODEURL
  134. EOMONTH
  135. ERF
  136. PRECISE
  137. ERFC
  138. PRECISE
  139. TYPE
  140. TYPE
  141. EVEN
  142. EXACT
  143. EXP
  144. DIST
  145. EXPONDIST
  146. DIST
  147. DIST.RT
  148. INV
  149. INV.RT
  150. TEST
  151. FACT
  152. FACTDOUBLE
  153. FALSE
  154. FDIST
  155. FILTERXMIL
  156. FIND
  157. FINV
  158. FISHER
  159. FISHERINV
  160. FIXED
  161. FLOOR
  162. MATH
  163. FORECAST
  164. ETS
  165. ETS.CONFINT
  166. ETS.SEASONALITY
  167. LINEAR
  168. FORMULATEXT
  169. FREQUENCY
  170. FTEST
  171. FV
  172. FVSCHEDUL
  173. GAMMA
  174. DIST
  175. INV
  176. GAMMADIST
  177. GAMMAINV
  178. GAMMALN
  179. PRECISE
  180. GAUSS
  181. GCD
  182. GEOMEAN
  183. GESTEP
  184. GETPIVOTDATA
  185. GROWTH
  186. HARMEAN
  187. HAX2BIN
  188. HEX2DEC
  189. HEX2OCT
  190. HLOOLUP
  191. HOUR
  192. HYPERLINK
  193. DIST
  194. HYPGEOMDIST
  195. IF
  196. IFERROR
  197. IFNA
  198. IMABS
  199. IMAGINARY
  200. IMARGUMENT
  201. IMCONJUGATE
  202. IMCOS
  203. IMCOSH
  204. IMCOT
  205. IMCSC
  206. IMCSCH
  207. IMDIV
  208. IMEXP
  209. IMLIN
  210. IMLOG10
  211. IMLOG2
  212. IMPOWER
  213. IMPRODUCT
  214. IMREAL
  215. IMSEC
  216. IMSECH
  217. IMSIN
  218. IMSINH
  219. IMSQRT
  220. IMSUB
  221. IMSUM
  222. IMTAN
  223. INDEX
  224. INDIRECT
  225. INFO
  226. INT
  227. INTERCEPT
  228. INTRATE
  229. IPMT
  230. IRR
  231. ISBLANK
  232. ISERR
  233. ISERROR
  234. ISEVEN
  235. ISFORMULA
  236. ISLOGICAL
  237. ISNA
  238. ISNONTEXT
  239. ISNUMBER
  240. ISODD
  241. ISOWEEKNUM
  242. ISPMT
  243. ISREF
  244. ISTEXT
  245. KURT
  246. LARGE
  247. LCM
  248. LEFT
  249. LEN
  250. LINEST
  251. LN
  252. LOG
  253. LOG10
  254. LOGEST
  255. DIST
  256. INV
  257. LOGNORMDIST
  258. LOOKUP
  259. LOWER
  260. MATCH
  261. MAX
  262. MAXA
  263. MDETERM
  264. MDURATION
  265. MEDIAN
  266. MID
  267. MIN
  268. MINA
  269. MINUTE
  270. MINVERSE
  271. MIRR
  272. MMULT
  273. MOD
  274. MODE
  275. MULT
  276. SNGL
  277. MONTH
  278. MROUND
  279. MULTINOMIAL
  280. MUNIT
  281. N
  282. NA
  283. DIST
  284. NEGDINOMDIST
  285. NETWORKDAYS
  286. INTL
  287. NOMINAL
  288. DIST
  289. INV
  290. S.DIST
  291. S.INV
  292. NORMDIST
  293. NORMINV
  294. NOT
  295. NOW
  296. NPER
  297. NPV
  298. NUMBERVALUE
  299. OCT2BIN
  300. OCT2DEC
  301. OCT2HEX
  302. ODD
  303. OFFFPRICE
  304. ODDFYIELD
  305. OLDLPRICE
  306. ODDLYIED
  307. OFFSET
  308. OR
  309. PDURATION
  310. PEARSON
  311. PERCENTILE
  312. EXC
  313. INV
  314. PERCENTRANK
  315. EXC
  316. INC
  317. PERMUT
  318. PERMUTATIONA
  319. PHI
  320. PI
  321. PMT
  322. POISSON
  323. DIST
  324. POWER
  325. PPMT
  326. PRICE
  327. PRICEDISC
  328. PRICEMAT
  329. PROB
  330. PRODUCT
  331. PROPER
  332. PV
  333. QUARTILE
  334. EXC
  335. INC
  336. QUOTIENT
  337. RADIANS
  338. RAND
  339. RANDBETWEEN
  340. RANK
  341. AVG
  342. EQ
  343. RATE
  344. RECEIVED
  345. REPLACE
  346. REPT
  347. REPT
  348. RIGHT
  349. ROMAN
  350. ROUND
  351. ROUNDDOWN
  352. ROUNDUP
  353. ROW
  354. ROWS
  355. PRI
  356. RSQ
  357. RTD
  358. SEARCH
  359. SEC
  360. SECH
  361. SECOND
  362. SERIESSUM
  363. SHEET
  364. SIGN
  365. SIN
  366. SINH
  367. SKEW
  368. P
  369. SLN
  370. SLOPE
  371. SMALL
  372. SQRT
  373. SQRTPI
  374. STANDARDIZE
  375. STDEV
  376. P
  377. S
  378. STDEVA
  379. STDEVP
  380. STDEVPA
  381. STEYX
  382. SUBSITUTE
  383. SUTOTAL
  384. SUBTOTAL
  385. SUM
  386. SUMIF
  387. SUMIFS
  388. SUMPRODUCT
  389. SUMSQ
  390. SUMX2MY2
  391. SUMX2PY2
  392. SUMXMY2
  393. SYD
  394. T
  395. DIST
  396. DIST.RT
  397. INV
  398. INV.2T
  399. TEST
  400. TAN
  401. TANH
  402. TBILLPRICE
  403. TBILLYIELD
  404. TDIST
  405. TEXT
  406. TIME
  407. TIMEVALUE
  408. TINV
  409. TODAY
  410. TRANSPOSE
  411. TREND
  412. TRIM
  413. TRIMMEAN
  414. TRUE
  415. TRUCN
  416. TTEST
  417. TYPE
  418. UNICHAR
  419. UNICODE
  420. UPPER
  421. VALUE
  422. VAR
  423. P
  424. S
  425. VARA
  426. VARP
  427. VARPRA
  428. VDB
  429. VLOOKUP
  430. WEBSERVICE
  431. WEEKDAY
  432. WEEKNUM
  433. WEIBULL
  434. DIST
  435. WORKDAY
  436. INTL
  437. XIRR
  438. XNPV
  439. XOR
  440. YEAR
  441. YEARFRAC
  442. YIELD
  443. YIELDDISC
  444. YIELDMAT
  445. ZTEST