
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#
Comentarios a estos manuales