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