Working with formulas
Using Quattro Pro, you can create math formulas. The following characters are used when creating a formula:
As well, a formula can use any of the following arguments:
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.

To create a text formula 
1.


Type a plus sign (+) in a blank cell.

2.


Type the formula using an ampersand (&) to combine text strings.

For example,+C4&”Review” enters the text in cell C4, then the word Review.

3.


Press Enter.

•


If you want to add a space between strings, type it inside the quotation marks. For example,+C4&” Review” enters the text in cell C4, a space, then the word Review.

To create a formula that evaluates to true or false 
1.


Click a blank cell.

2.


Type a formula using one of the logical operators.

3.


Press Enter.

•


If the statement is true, a 1 displays in the cell. If the statement is false, a 0 displays.

•


For an explanation of operators, see “Operator precedence.”

To display error sources in cells 
1.


Click Format Notebook properties.

2.


Click the Recalc settings tab.

3.


Enable the Audit errors check box.

To convert a formula to a value 
1.


Select a cell containing a formula.

2.


Click Edit Convert to values.

3.


Type the destination cells in the To box.

•


To replace a formula in a cell with its value, specify the same cells in the To box as are in the From box.

•

&nbs
p; 
To copy the value of a formula to another part of the notebook, specify the topleft cell to which you want to copy the value.

•


You can also specify the addresses of the destination cells by clicking the Range picker to the right of the relevant box and selecting a cell.
