Calculations in Calc. Creating and Coping Formulas

Functions and Formulas are powerful tools in spreadsheets which can save you hours of work.

Functions are routines that are built into the Calc spreadsheet—in other words, there’s not much you need to do to set them up and make them work.

Formulas, on the other hand, are defined by the user—in other words, you have to know what you’re doing and set everything up yourself. Formulas will often include the built-in functions as part of the formula.

Both functions and formulas accomplish the same task: they tell Calc to do some kind of more or less complex or time-consuming calculation for you.

The "=" symbol at the beginning is a clue to the system that what follows is a function or formula.

ALL SPREADSHEET FORMULAS BEGIN WITH THE EQUALS = SIGN.

Then the expression is written. To write down arithmetical expression use numeric constants, cell’s addresses, intrinsic functions, and arithmetic operations +, -, *, /, ^. For example,

=A1*2,5 =B2+C2+D2 =C2*10%/5 =SIN(2*F4)+1 =SUM(B2:B9)

The formula =SUM(D10:H10) tells Calc to sum (add together) the scores entered in cells D10 through H10 and store the result in cell J10 (cell J10 is the cell in which you want the formula to put the result of doing its calculation).

SUM is one of many Calc built-in functions. It ADDS UP or TOTALS the series of additions to produce the required result.

Calc has such Category of function: Database, Date&Time, Information, Financial, Logical, Mathematical, Statistical, Spreadsheet, and Text sets of built-in Functions.

The addresses of cells or ranges can be the arguments of functions. The range is continuous rectangular area of cells, the address of a range is set by the indication of the right top cell and through a colon left bottom cell. For example, C2:D4 is range that consists of 6 cells.

Table 3.1. Mathematical functions.

Function(engl)	Description
ABS(x)	½x½ - absolute value of x
ACOS(x)	Arccos(x)
ASIN(x)	Arcsin(x)
ATAN(x)	Arctg(x)
COS(x)	Cos(x)
EXP(x)	e^x
LN(x)	Ln(x)
LOG(x;a)	Loga x
SIN(x)	Sin(x)
TAN(x)	Tg(x)
SQRT(x)	Square root value x -
Power(x,a)
MINVERSE(m)	Formula array. Returns the inverse matrix, the argument m is range
MDETERM(m)	Returns the determinant of given matrix from range m
MMULT(m1;m2)	Formula array. Returns the matrix – production of matrixes from ranges m1 and m2
PI()	Returns the value of number p
SUM(d)	Returns the sum of all numbers from range d

Дата добавления: 2015-10-29