O'Reilly logo

StarOffice™ 5.2 Calc Handbook by Joe Habraken

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required