Watlow ANAWIN 2 - Manual (Page 130)

B-2 AnaWin User’s Guide
User Variable Operators and Functions
NOTE
The exponentiation operator cannot be used to take roots of nega-
tive numbers. Do not attempt to raise a negative number to a power
between zero and one. Do not use the exponentiation operator to
raise a user variable that may become negative to a power between
zero and one.
Available Functions
The following functions are available as math expressions. The letter A
represents a relational expression, for example, A1 > B1. The letters B
and C represent references to cell or mathematical expressions that
contain cell references. The letter D represents the amount of precision.
ABS(B): The absolute value of the cell is returned.
ADD(A,B): Adds the two elements.
IF(A,B,B,C): If A is nonzero, then B is returned. If A is zero, then C is
returned. A can contain one of the relational operators: greater than (>),
less than (<), equal to (=), or not equal to (!).
ISEMPTY(B): If B is empty then a 1 is returned. If B is not empty then
a zero is returned.
MAX(A,B, . . .): Returns the maximum value of all arguments. Accepts
a variable number of arguments. Each argument can be a cell range, a
float value, or an integer value.
MIN(A,B, . . .): Returns the minimum value of all arguments. Accepts a
variable number of arguments. Each argument can be a cell range, a
float value, or an integer value.
NEG(B): Changes the sign of the value. For example, NEG (15) = 15.
NOT(B): If B is zero then a 1 is returned. If B is not zero then a zero is
returned.
ROUNDUP(B,D): Rounds the value up to the next whole number,
using the specified number of decimal places (D). A zero can be used
for no decimal places. Negative precision specifies tenths, hundredths,
etc.
ROUND(B,D): Rounds the value to the nearest whole number, using
the specified number of decimal places (D). A zero can be used for no
decimal places. Negative precision specifies tenths, hundredths, etc.