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.
