Loading ...
Loading ...
Loading ...
39
Functions and their arguments
Supply the information PenCell needs to carry out a
function. For example, when PenCell comes across the
function SUM(A4:A20), the argument A4:A20 tells
PenCell to add the values in the range extending from
A4 to A20. The number and type of arguments required
varies by function. The functions in the function list of
the PenCell formula editor display a template of the
arguments that each function requires.
Arguments can be values, cell references, and condi-
tions:
• For values, use a number (such as 2), a numeric
formula (such as 2+3 or A1+B1), or a cell or range
reference that contains a number or numeric formula
(such as A4 or A4:A20).
• For cell or range references, type the reference or
touch the cell or range when the cursor is to the right
of a parenthesis or an arithmetic operator (+, -, >,
etc.).
• For conditions, use a logical formula or the reference
of a cell that contains a logical formula. You can also
use any numeric formula, literal string, or cell refer-
ence.
• PenCell assigns the value 0 to blank cells used as
arguments in financial, logical, and mathematical
functions.
• A blank cell is ignored in the computation of statistical
functions: MIN, MAX, AVERAGE, STDEVP and VARP.
NOTE
Your unit provides a way of entering symbols like > and
< or { and }. Press SMBL to see the list of symbols.
Touch one to enter it to the selected cell.
Errors when formulas are calculated
Two kinds of error messages are available to help you
evaluate errors when they occur.
• #REF appears in a cell when a cell reference in a
formula is invalid.
• #ERR appears in a cell when a numeric error occurs.
There are some conditions that cause an error when
formulas are calculated.
• A zero as denominator in the formula.
• An incorrect parameter range in a function.
• Error in a function used in a formula. For instance,
ASIN(2) evaluates to #ERR.
• A #REF error occurs when a cell reference in a
formula becomes invalid after the formula is copied, or
a cell referenced in a formula is deleted.
NOTE
If you enter an invalid formula that begins with an
alphabetical character, PenCell interprets the formula as
a label.
Loading ...
Loading ...
Loading ...