Chapter 16. Mathematical and Trigonometry Functions

• Functions for Mathematical Calculations

• Functions for Trigonometry Calculations

• Other Functions

• ABS()

• ACOS()

• ACOSH()

• AGGREGATE()

• ASIN()

• ASINH()

• ATAN()

• ATAN2()

• ATANH()

• CEILING()

• CEILING.PRECISE()

• COMBIN()

• COS()

• COSH()

• DEGREES()

• EVEN()

• EXP()

• FACT()

• FACTDOUBLE()

• FLOOR()

• FLOOR.PRECISE()

• GCD()

• INT()

• LCM()

• LN()

• LOG()

• LOG10()

• MDETERM()

• MINVERSE()

• MMULT()

• MOD()

• MROUND()

• MULTINOMIAL()

• ODD()

• PI()

• POWER()

• PRODUCT()

• QUOTIENT()

• RADIANS()

• RAND()

• RANDBETWEEN()

• ROMAN()

• ROUND()

• ROUNDDOWN()

• ROUNDUP()

• SERIESSUM()

• SIGN()

• SIN()

• SINH()

• SQRT()

• SQRTPI()

• SUBTOTAL()

• SUM()

• SUMIF()

• SUMIFS()

• SUMPRODUCT()

• SUMSQ()

• SUMX2MY2()

• SUMX2PY2()

• SUMXMY2()

• TAN()

• TANH()

• TRUNC()

The Microsoft Excel functions for standard mathematical and trigonometry calculations (see Table 16-1) can be divided into the following groups:

• Functions for general mathematical calculations

• Functions for trigonometry calculations

• Functions that cannot be assigned to mathematical or trigonometric calculations