beautypg.com

Ptab menu options – Juniper Systems Allegro CX Manual User Manual

Page 135

background image

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.

‰
‰
‰
‰
‰
‰