Understanding Formulas

Every calculation is considered a formula, even something as simple as 3+3. To build a formula, you have to start it with one of the following symbols: /, $, (, @, #, ., %, or =. A formula might contain numbers, cell addresses, cell names, and operators. If a formula starts with a cell address, such as C4*D8, you must put a symbol in front of it or Quattro Pro will treat it like a label.

When you create a formula in a cell, the result of the formula is displayed in the cell, not the formula itself. If you select a cell with a formula, the formula is displayed in the input line where you can edit it. You cannot edit the result of a formula—you can only edit the formula itself.

If you are new to formulas, some of these concepts ...

Get Absolute Beginner's Guide to WordPerfect® 12 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.