< Day Day Up > |

Calc is designed to do calculations. Although many built-in formulas and functions are provided by Calc, in some situations you will need to build your own formulas. These formulas typically involve simple math operations such as subtraction, multiplication, and division. All formulas that you create must begin with the equal sign (=). This tells Calc that the information that follows the equal sign is a formula. To designate what type of calculation you want Calc to perform you use a mathematical operator (see Table 12.1).
You enter the cell addresses for the cells that will be acted on by the formula. For example, B5*C5 multiplies the contents of B5 times the contents of C5. When you design your own formulas, keep the natural order of math operator precedence in mind: Exponents are computed first, then multiplication and division, followed by addition and subtraction. To force the precedence you can place portions of your formula in parentheses. This part of the formula is computed first. |

< Day Day Up > |

Novell Linux Desktop 9 Users Handbook

ISBN: 0672327295

EAN: 2147483647

EAN: 2147483647

Year: 2003

Pages: 244

Pages: 244

Authors: Joe Habraken

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