B user variable operators and functions, Available operators, User variable operators and functions – Watlow ANAWIN 2 User Manual

Page 129

Text mode
Original mode

AnaWin User’s Guide B-1

User Variable Operators

and Functions

This appendix lists the operators and functions that may be used on the
Formulas and User Defined Variables spreadsheet.

Available Operators

The following table lists the operations available as math expressions.

Operator

Description

Literal /

Literal

Cell Ref /

Literal

Cell Ref /

Cell Ref

Addition

2 + 2

A1 + 2

A1 + B2

Subtraction

4 - 2

A1 - 2

A1 - B2

Exponentiation

2 ^ 2

A1 ^ 2

A1 ^ B2

Multiplication

2 * 2

A1 * 2

A1 * B2

Division

2 / 2

A1 / 2

A1 / B2

Logical AND

2 & 2

A1 & 2

A1 & B2

Logical OR

2 | 2

A1 | 2

A1 | B2

Creates a range

A1: B2

Wild card

A# * 2

A# * B#