Creating Spreadsheet Formulas
One of the most important characteristics of a spreadsheet application like Calc is that it is designed to do math. The whole point behind building a spreadsheet is to have the data that we enter into the spreadsheet acted on by a formula or formulas; we are looking for mathematical results.
As discussed briefly in Chapter 2, you have two options for performing math in a Calc spreadsheet: you can design your own formulas, or you can use the built-in math functions that are provided by Calc.
In this chapter, we will discuss the ins and outs of creating your own formulas and some of the enhancements and features provided by Calc that make it easier to work with formulas, functions, and values. Functions will be covered ...
Get StarOffice™ 5.2 Calc Handbook 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.
