• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part III: Function Reference > Mathematics and Trigonometry Functions

Chapter 14. Mathematics and Trigonometry Functions

Excel provides a variety of mathematical and trigonometrical functions. These functions let you perform most of those calculations you had to figure out by hand in high school trig and calculus classes. And if you are like me, you haven't had to do these types of equations since then. Excel makes it easy for the math-challenged by running these calculations. (Of course, now most students are allowed to execute these calculations on calculators or computers.) The following functions are covered in detail in this chapter. The "AT" represents those functions that exist only by loading the Analysis Toolpak. See Chapter 11 for details.

ABS LN ROUNDUP
ACOS LOG SERIESSUM AT
ACOSH LOG10 SIGN
ASIN MDETERM SIN
ASINH MINVERSE SINH
ATAN MMULT SQRT
ATAN2 MOD SQRTPI AT
ATANH MROUND AT SUBTOTAL
CEILING MULTINOMIAL AT SUM
COMBIN ODD SUMIF
COS PI SUMPRODUCT
COSH POWER SUMSQ
DEGREES PRODUCT SUMX2MY2
EVEN QUOTIENT AT SUMX2PY2
EXP RADIANS SUMXMY2
FACT RAND TAN
FLOOR RANDBETWEEN AT TANH
GCD AT Roman TRUNC
INT ROUND 
LCM AT ROUNDDOWN 



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint