Mathematical functions
Most functions in the Math & Trig group take one argument: SQRT(x) is the square root, ABS(x) the absolute value, EXP(x) e to the power x, LN(x) the natural logarithm, and POWER(a, b) is a to the power b (the same as a^b). SIN, COS and TAN expect the angle in radians, RADIANS(d) converts degrees, and PI() gives π ≈ 3.14159. A composite function, for example sin(eˣ), is written =SIN(EXP(A2)): the inner function is calculated first and its result becomes the argument of the outer one. An argument can be a cell, a number or another function. In a table of a function of two variables such as z = sin x + cos y, the x values are in the first row and the y values in the first column, and the formula uses mixed references: =SIN(B$1)+COS($A2). To show results neatly use ROUND or the “Decrease Decimal” button.
| Function | Meaning |
|---|---|
| SQRT(x) | square root |
| ABS(x) | absolute value |
| EXP(x) | eˣ |
| LN(x) | natural logarithm |
| POWER(a, b) | aᵇ |
| RADIANS(d) | degrees to radians |
| PI() | π |
A pupil wants to model the swing of a playground swing. First the angle is converted from degrees to radians, then the sine is taken of that result. The order matters: the second step cannot be done until the first is finished.
Engineers, game programmers and physicists describe motion with chains of functions.
Make a three-step “number machine” on paper: pick any number, double it, subtract 3, then square the result, and work from the inside outwards.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | x | SIN(x) | EXP(–x) | SIN(EXP(–x)) | SQRT(1+SIN(x)) |
| 2 | 0.5 | 0.4794 | 0.6065 | 0.5700 | 1.2163 |
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 0 | 0.5 | 1 | |
| 2 | 0 | 1.0000 | 1.4794 | 1.8415 |
| 3 | 0.5 | 0.8776 | 1.3570 | 1.7191 |
| 4 | 1 | 0.5403 | 1.0197 | 1.3818 |
“From the inside out”: the teacher writes a composite function (for example, ln(cos x + 2)); students say which function is calculated first and write the Excel formula in their notebooks (=LN(COS(A2)+2)).