The general form of an Objective Grid formula is:
= expression ; constraint expression // comment
Where expression defines the calculations needed to generate the cell"s value, constraint expression places limits on acceptable values or the circumstances under which the calculation should take place, and comment is any text you want to attach to the cell. The expression part of Objective Grid formulas looks just like an algebraic formula; it contains values and operators that define the relationships between values. Objective Grid uses the following conventions for formulas:
ü A formula must begin with an equal
(=) sign. When you begin typing into a cell, Objective Grid automatically
assumes that you are typing a formula if you start with one of the following
characters:
0 1 2 3 4 5 6 7 8 9 . - @ =+
ü Formulas can have as many as 511 characters. You can type spaces if you wish, but Objective Grid automatically removes them.