The Average() function, for example, computes an average of whatever list of values you pass in the argument. Functions generally manipulate data ( numbers or text), and the arguments inside the parentheses supply the data to the functions. If a function contains only a single argument, do not use a semicolon inside the parentheses. When using multiple arguments in a function, separate the arguments with semicolons. A function might use zero, one, or more arguments, depending on how much information the function needs to do its job. A function accepts zero or more arguments.
Instead of writing a formula to sum a row or column of values, for example, you would use the Sum() function.įunction names always end with parentheses, such as Average(). In addition, such long formulas are likely to produce errors when you have to type so much.įortunately, Calc includes several built-in functions that perform many common mathematical calculations.
You would type a formula such as =F2+F3+F4+ and would likely run out of roomand patience!before you complete the formula. Suppose you want to add all the values in a column of 100 cells. Entering individual formulas can get tedious.
0 kommentar(er)
