< Day Day Up > |

Without formulas , Calc would be little more than a simple row-and-column-based word processor. When you use formulas, however, Calc becomes an extremely powerful timesaving, planning, budgeting, and general-purpose financial tool. Before You Begin 37 About Sheets and Spreadsheets See Also 44 Copy and Move Formulas On a calculator, you typically type a formula and then press the equal sign to see the result. In contrast, all Calc formulas begin with an equal sign. For example, the following is a formula: =4*2-3 KEY TERM
The asterisk is an operator that denotes the times sign (multiplication). This formula requests that Calc compute the value of 4 multiplied by 2 minus 3 to get the result. When you type a formula and press Enter or move to another cell, Calc displays the result and not the formula on the worksheet. When you enter Calc displays a formula's result in the cell. Table 6.3 lists the primary math operators you can use in your worksheet formulas. Notice that all the sample formulas begin with the equal sign. ## Table 6.3. The Primary Math Operators Specify Math Calculations
KEY TERM
NOTE
You can combine any and all the operators in a formula. When combining operators, Calc follows the traditional computer (and algebraic) operator hierarchy model . Therefore, Calc first computes exponentiation if you raise any value to another power. Calc then calculates all multiplication and division in a left-to-right order (the first one to appear computes first) before addition and subtraction (also in left-to-right order). The following formula returns a result of =18 - 2 ^ 3 / 4 * 2 If you want to override the operator hierarchy, put parentheses around the parts you want Calc to compute first. The following formula returns a different result from the previous one, for example, despite the same values and operators used: =(18 - 2) ^ 3 / 4 * 2 Instead of To add three cells together, you could type the following in another cell: ` =D3+K10+M7 ` Calc adds the values in D3, K10 , and M7 and shows the result in place of the formula. The cells D3, K10 , and M7 can also contain formulas that reference other cells. |

< Day Day Up > |

Sams Teach Yourself OpenOffice.org All In One

ISBN: 0672326183

EAN: 2147483647

EAN: 2147483647

Year: 2003

Pages: 205

Pages: 205

Authors: Greg Perry

flylib.com © 2008-2017.

If you may any questions please contact us: flylib@qtcs.net

If you may any questions please contact us: flylib@qtcs.net