Understanding Calc Functions
In the previous chapter, we took a look at how you create your own formulas and some techniques for entering data, particularly values, into your spreadsheets. In this chapter, we'll take a look at Calc's built-in formulas—functions.
Functions can do everything from adding a range of numbers, to counting the number of entries in the range, to providing you with a amortization calculation that lets you know how much you owe on your car based on the term, amount of the loan, and interest rate.
Functions consist of two parts: the function name (which takes care of the calculation) and the cells that will be acted upon by the function. For example, the function =avg(B5:B12) will return an average value for the cell range ...
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.
