Chapter 8 Pocket Sheet
Examples
The following are some examples of mathematical expressions you can input into sheet cells.
Cell Contents |
| Displayed Result |
0 |
| |
=(1+2)*(3+4) | 21 | |
=(A1+B5)*2 | Result of expression using contents of cells A1 | |
| and B5 | |
|
| |
=$A$1+B2 | Contents of cell A1 + Contents of cell B2 | |
|
|
|
=2^3 | 8 | (Raises left value to power specified by right |
| value.) | |
|
| |
=ABS(A1) | Absolute value of value in A1 | |
|
| |
=AVERAGE(A1:D5) | Average of values in cells A1 through D5 | |
|
| |
=COUNT(A1:D5) | Number of values in cells A1 through D5 | |
=COUNTA(A1:A7) | Number of non blank cells in cells A1 through | |
| A7 | |
=EVEN(3) | 4 | (Rounds up to the nearest even number.) |
|
|
|
=INT(8.9) | 8 | (Rounds down to the nearest integer.) |
|
| |
=MAX(A1:D5) | Greatest value of those in cells A1 through D5 | |
|
| |
=MIN(A1:D5) | Least value of those in cells A1 through D5 | |
|
|
|
=MOD(3,2) | 1 | (Integer result when left value is divided by |
| right value.) | |
|
| |
=ODD(2) | 3 (Rounds up to the nearest odd number.) | |
=ROUND(2.15,1) | 2.2 (Rounds left value to decimal places | |
| specified by right value.) | |
=SQRT(A1*5) | Square root of value in cell A1 multiplied by 5 | |
|
| |
=SUM(A1:D5) | Sum of contents of cells A1 through D5 | |
|
|
|
90