Page 263 - open office
P. 263
Formula with Cell Names
In Calc , Formula can be applied with reference to cell names. For doing so, first define the name of the cell
or the range of cells.
For naming a cell, click on the cell and type the name for that cell in the address to replace the cell address
(co-ordinates) with the name and press the ‘Enter’ key. Name can be used directly in a formula.
For example: Consider a worksheet that has the following details:
A B C D E
1 Name_of_Sales_Man Sale in 2 15 Sale in 2 16 Sale in 2 1 Total_Sale
2 Kumar arayan 25
In the address bar, assign the cell A1 as ame of Sales Man, B1 as Sale in 2 15, C1 as Sale in 2 16, D1 as
Sale in 2 1 and E1 as Total Sale. Enter the values in the cells A2, B2, C2 and D2 as Kumar arayan, ,
, respectively.
ow, enter a formula in cell E2, say Sale in 2 15 Sale in 2 16 Sale in 2 1 . After pressing the Enter
key, the output will be shown as 25 in cell E2 .
Formula with In-built Functions
Functions are in-built formula in ‘Calc’ that
can be used to perform arithmetical and non- =SUM(A1:A5)
arithmetical tasks. In ‘Calc’, there are more
than 3 5 in-built functions that can be applied
directly or as a part of a formula. A function Name Argument
contains ‘Name’ & ‘Argument’.
For Example: A formula, say as A6 A1 A2 A3 A4 A5 can be written using the SUM function along with
the cell range as: A6 SUM(A1:A5)
ame is the name of the function that signifies the nature of operation. Argument specifies the values or
the range of cells on which the specific operation is being applied and is always enclosed within the opening
and closing parenthesis (i.e. Name refers to the operator and Argument refers to the operand).
N ot e s
esent
esent
epr
epr
betw
betw
ed
ed
f
it
f
cells,
cells,
r
r
is
it
is
een
f
the
o
f
the
st
st
fir
fir
o
colon
with
een
colon
with
ess
ess
addr
addr
t
t
orksheet,
denot
o
o
In
In
In Worksheet, to denote a range of cells, it is represented between colon with address of the first
orksheet,
W
W
denot
a
a
range
range
e
o
o
e
cell last cell, i.e., say a range of cells from A1 to A5 will be denoted by A1 : A5 .
cell last cell, i.e., say a range o f cells fr om A1 t o A5 will be denot ed by A1 : A5 .
cell last cell, i.e., say a range of cells from A1 to A5 will be denoted by A1 : A5 .
T
To apply function between the selected cells among the range of cells, a semicolon (;) is used,
To apply function between the selected cells among the range of cells, a semicolon (;) is used,
f cells, a semicolon (;) is used,
ed cells among the range o
een the select
o apply function betw
A1 A2 is applied.
i.e., for denoting two cells A1 and A2, A1 A2 is applied.
o cells A1 and A2,
i.e., for denoting tw
i.e., for denoting two cells A1 and A2, A1 A2 is applied.
OPERATOR
An operator is a symbol that performs certain mathematical or logical operations. In a cell, the calculation
takes place in the order of precedence of operators (in a similar way as BODMAS in mathematics).
The table given below shows the operators, their meaning and their order of execution. When two operators
share the same ranking or precedence, calculation is done in the order from left to right.
Working with Spreadsheet 263

