37
Types of formulas
There are three types of formulas: numeric, logical, and
date.
Numeric formulas
Numeric formulas perform calculations with numbers,
using one or more of the arithmetic operators +, -,
*
, /, ^,
or related built-in functions.
Two examples of numeric formulas are 3
*
B20 and
SUM(B20:B25)/4. The formula 3
*
B20 returns a numeric
value by multiplying 3 by the value in cell B20. The
formula SUM(B20:B25)/4 returns a numeric value by
dividing the sum of the values in the range B20:B25 by 4.
Logical formulas
Logical formulas are statements that return true (value
1) or false (value 0). For example, the logical formula
B5>=40 returns true (1) if cell B5 contains a value
greater than or equal to 40. Otherwise, the formula
returns false (0). Logical formulas use the logical and
relational functions described in the following pages.
Date formulas
Date formulas return results expressed as dates or time.
About built-in functions
A formula can include one or more built-in functions. You
can include built-in functions in your worksheet by
typing them or, more simply, by inserting them using the
icon. See Appendix B, “
Function Reference
” for
details. This section gives you some general information
about using the functions.
Types of functions and operators
PenCell supports six major types of functions and
operators:
Arithmetic
Perform arithmetic operations. These include:
*
, +, -, /, ^, ABS, INT, ROUND, SQRT, EXP, LN,
LOG, LOG10, MOD, RAND, PI, SUM.
Date/Time
Compute values based on dates and times. These
functions use the unit's clock, so the clock must be
set properly for date and time values to be
accurate. These include: DATE, DATEVALUE,
DAY, HOUR, MINUTE, MONTH, NOW, SECOND,
TIME, TIMEVALUE, TODAY, YEAR.
To Next Page
Loading...
Need help?
General
