## 44. About Calc FormulasBEFORE YOU BEGIN 38 About Sheets and Spreadsheets SEE ALSO 45 Copy and Move Formulas 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. KEY TERM Formulas Equations composed of numeric values and often cell addresses and range names that produce a mathematical result. 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 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 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
Calc displays a formula's result in the cell. 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). KEY TERM Operator hierarchy model A predefined order of operators when equations are being calculated. 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 NOTE Formulas can contain cell addresses, cell names, and other values besides numbers . See 49 About Calc Ranges for more information about range names. 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. |

Sams Teach Yourself OpenOffice.org 2, Firefox and Thunderbird for Windows All in One

ISBN: 0672328089

EAN: 2147483647

EAN: 2147483647

Year: 2005

Pages: 232

Pages: 232

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