|
| |
Contents | Index
Spreadsheet Calculations
Formulas always begin with an equals sign (=). They may include cell references, numbers, dates and times, functions and operators. Besides the four arithmetic operators(+, -, *, /)
and the power operator (^), the functions available are shown in the list below.
The result of a formula that is numeric will be right-justified. All else will
be left-justified. Any text that you enter will be assumed to be a cell
reference unless you enclose it in double quotes (""). To force something that is
right-justified to be left-justified, precede it with a single quote ( ' )
Note:
- In order to conveniently reference columns and rows in the Data Editor, turn
on Show Row numbers and Column letters option in the Preferences dialog box, available from the Options menu.
- A formula based upon one or more blank cells will yield an invalid result
(#N/A) if the Treat blank cells as zeroes option in the Preferences dialog box is NOT selected. If this option is selected, blank cells will be treated as a 0.0 for the
purposes of calculations. In all cases a non-numerical value is treated as a
missing value in charts. Note however that any cells that contains a number within it
somewhere will be accepted using that numeric value. For example "$35.46"
will be interpreted as 35.46, as would "Alice 35.46".
:
| sum
| abs(n)
| absolute value of n
| acos(n)
| arc cosine of n
| asin(n)
| arc sine of n
| atan(n)
| arc tangent of n
| cos(n)
| cosine of n
| cosh(n)
| hyperbolic cosine of n
| exp(n)
| exponential function of n
| ln(n)
| natural logarithm of n
| log10(n)
| base 10 logarithm of n
| pow10(n)
| raise 10 to the power of n
| rand(n)
| random number between 0 and n
| round(n)
| round to the nearest whole number
| sin(n)
| sine of n
| sinh(n)
| hyperbolic sine of n
| sqr(n)
| square of n
| sqrt(n)
| square root of n
| tan(n)
| tangent of n
| tanh(n)
| hyperbolic tangent of n
| trunc(n)
| return the whole part of n
|
examples:
=b1:d1 the sum of cells b1, c1 and d1
=ln(sqr($a$2)) the natural log of the square of the value in cell a2.
=sinh(.12) the hyperbolic sine of the number .12.
=sqrt(b4) + sqrt(c4) the sum of the square roots of the values in relative cells b4 and c4.
|
