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

Page 129

Advertising
background image

AnaWin User’s Guide B-1

B

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#

Advertising