# 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

Use these functions to do the following:

• Make sure a numeric value is positive.

• Round numbers up or down.

• Make sure a numeric value is an even number.

• Truncate a numeric value to the specified number of decimal places.

• Determine the square root of a number.

• Determine if a numeric value is positive or negative.

• Calculate any of the common trigonometrical functions, ...

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.