Main Functions and
Formula used in Excel.
There are many
pre-defined functions in Excel but the most important predefined
functions are:
-
SUM function.
-
AVERAGE function
-
MAX function
-
MIN function
-
PRODUCT function
-
IF function
SUM Function
It is used to add numbers given as parameters. These may be numeric
values
or cell references. Its general syntax is:
SUM(numberl,number2,
.,.)
Where
numberl, number2,...
: specifies arguments which you want to add.
For example, = SUM (3, 2) returns 5.
Similarly,
to
add values of
cell
range Al to A30, the function
is written as:=SUM
(A1:A30)
AVERAGE Function
It is used to calculate the average of values given as parameters. These
may be numeric values or cell references. Its general syntax is:
AVERAGE (numberI, number2, ...)
Where
numberl, number2,...
: specifies arguments for
which
you
want to
calculate average. For example. AVERAGE.
(3, 2) returns 2.5.
Similarly,
to
calculate average of values of
cell range Al to A30. the
function is
written as:=AVERAGE(A1:A30).
MAX Function
It returns the largest or maximum value from a list of values.
The parameters
may be numeric values or cell
references. Its general syntax
is:
MAX (numberl, number2, ...)
Where
numberl, number2,...
:
specifies arguments from which you want to
find maximum,
for example, =MAX(3.
2,45,23) returns 45.
MIN
Function
It
returns
the lowest or minimum value From a
list
of
values.
The parameters
may be
numeric
values or
cell references,
its
general syntax is:
MIN(number 1, number2….)
Where
numberl, number2,...
: specifies arguments from which you want to find minimum. For
example, =M1N(3, 2,45,23) returns 2.
PRODUCT Function.
It is used to
multiply
numbers given as parameters. These
may be numeric values or
cell
references. Its general syntax is:
PRODUCT (number1 ,number2, ...) where
numberl, number2,...
:
specifies
arguments which you want to
multiply. For example, =PRODUCT
(13, 2) returns 26.
Similarly,
to multiply
values of cell range Al to
A30, the function is written as:=PRODUCT
(A 1:A30).
COMPUTER TIPS