Juniper Systems Allegro CX Manual - Manual (Page 135)

Allegro CX Owner’s Manual 135
- Boolean: True or false
- Formula: Formulas begin with an equal sign (=). PTab evaluates the
value. (Example: =A5+2, =Sum(B2:C7)).
Formulas can contain:
Number, text, date/time, Boolean values
Cell references (examples: A4, $B7, $C$3,
Sheet1!A3,’2ndSheet’!$C$7)
Cell ranges (examples: A1:B4, ‘Year 2003’!C5:D7)
Arithmetic operations: +, -, /, *, %, ^ (examples: A1*B5%,
C7*100-5)
Comparative operators: =, <, <>, >, <=, >= (example: if(A1>B1,
A1, B1))
Text joining operators: & (example: A1 & “years”)
Functions
PTab Menu Options
The PTab pull-down menu options include:
File
Edit
Insert
Format
Tools
Task
Each menu option is described in detail on the following pages.
On-line help is accessed by pressing the [?] in the upper right- hand
corner of the screen.
▲
‰
‰
‰
‰
‰
‰