### Working with formulas

Using Quattro Pro, you can create math formulas. The following characters are used when creating a formula:

 Character Result . establishes the following data as a value + establishes the following data as a positive value - establishes the following data as a negative value ( ) establishes the following data as a formula and calculates first anything contained in the parentheses @ establishes the following data as a function # establishes the following data as a logical equation \$ establishes the following data as a currency value = establishes the following data as a value

As well, a formula can use any of the following arguments:

 Argument Examples Numbers 1948, -84, 43.23, 12½ Cell coordinates B12, G29..G31, B:A3..D6, or [NOTEBK2]A:A1 Cell names EXPENSES (which may reference D5..D10) Spreadsheet functions @SUM(B1..B24) Text set off by ” “ “PROFIT” or “Dear Mr.”

You create formulas using cell data, such as column totals.

You can also create text formulas. Text formulas are any formulas that have a textual result.

Quattro Pro also allows you to create logical formulas that evaluate true or false. For example, the result of the formula +C3<10 displays either 1 or 0 depending on the value of cell C3.

Displaying error sources directly in your cells shows you the cause of any problem with your formula. As well, you can convert formulas to values; the value appears in the cell and the input line, replacing the formula.

For additional information about creating formulas, see “Operator precedence”, “Guidelines for solving errors in formulas”, and “Working with arrays”.

#### To create a math formula

 1 Type a plus sign (+) in a blank cell.
 2 Type a formula.
 3 Press Enter.

 • To view formula results as you enter the formula data, press F9.

#### To create a formula from cell data

 1 Type a plus sign (+) in a blank cell where you want to enter the formula.
 2 Begin typing the formula
 3 Click the cell that contains the data to insert in the formula.
 4 Finish typing the formula.