Understanding Formula Syntax
OpenOffice.org Calc formulas look and behave a lot like the equations you learned in your math classes, only the equal sign (=) is on the left hand side of the equation, rather than on the more “natural” right hand side.
All of the standard mathematical operators are available for your perusal, and they look and work just as in any other spreadsheet or math software. Their names and symbols are as follows:
- Addition (+)
- Subtraction (–)
- Multiplication (*)
- Division (/)
- Exponentiation (^)
OpenOffice.org Calc follows the standard mathematical order of operations: exponentiation, multiplication, and division (from left to right), and addition and subtraction (from left to right).
You can change the order of formula evaluation ...
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
