Functions
Functions:
Functions are predefined expressions (formulas) that perform
calculations using values called function arguments.
Each function has its own syntax: function name (argument,
argument2,...).
Methods of entering functions:
Direct entering is a complex method of entering function,
because it implies knowledge of its syntax.
Insert function button:
Insert function button on the Formula Bar.
Via the Home tab, within Editing group, click on the arrow next
to the icon that opens the drop-down menu.
Via the Formulas tab - select the cell in which you want to display
the result and on the Formulas tab choose the Insert Function icon
cont.,
SUM function
SUM function adds all numbers within certain range of cells. Its
syntax is SUM(number1, number2,...), where number1 and
number2 represent the series of arguments (10-30) we want to add.
AVERAGE function
AVERAGE function is used to calculate the arithmetic mean (average). Its
syntax is: AVERAGE(number1, number2,...), where number1 and
number2 represent the series of arguments (10-30) whose average
value we want to determine.
MIN and MAX functions
MIN and MAX functions determine the minimum or maximum value from
a default set of values. Syntax is as follows: MIN(number1,
number2,...) and MAX(number1,number2,...).
Student Marks Example: (SUM
Function)
MAX Function Example:
If function
The IF function is one of the most popular functions in Excel, and
it lets you make logical comparisons between a value and what
you expected.
So an IF statement can have two results. The first result is if your
comparison is True, and the second if your comparison is False.
Syntax:
=if(condition, value if true, value if false)
=if(c2>8,1,0)
=if(c2>8,”true”,”false”)
AND Function:
The AND function is a logical function used to require more than one
condition at the same time. AND returns either TRUE or FALSE. For example
to test if a number in A1 is greater than zero and less than 10, use
=AND(A1>0,A1<10).
Purpose:
Test multiple conditions with AND.
Return value:
TRUE if all arguments evaluate TRUE; FALSE if not.
Syntax:
=AND (logical1, [logical2], ...)
Example:
OR Function:
The OR function is a logical function to test multiple conditions at the
same time. OR returns either TRUE or FALSE. For example, to test A1 for
either "x" or "y", use =OR(A1="x",A1="y").
Purpose:
Test multiple conditions with OR
Return value:
TRUE if any arguments evaluate TRUE; FALSE if not.
Syntax:
=OR (logical1, [logical2], ...)
Example:
COUNTA Function
The Excel COUNTA function returns the count of cells that contain numbers,
text, logical values, error values, and empty text (“ "). COUNTA does not count
empty cells.
Purpose:
Count the number of non-blank cells.
Return value:
A number representing non-blank cells.
Syntax:
=COUNTA (value1, [value2], ...)
Example:
SQRT Function
To get the square root of a number, you can use the SQRT function. The
SQRT function is fully automatic and will return the square root of any positive
number.
ABS Function
The Excel ABS function returns the absolute value of a number. Negative
numbers are converted to positive numbers, and positive numbers are unaffected.
Purpose:
Find the absolute value of a number.
Return value:
A positive number.
Syntax:
=ABS (number)
Examples:
POWER Function
The Excel POWER function returns a number to a given power. The POWER
function works like an exponent in a standard math equation.
Purpose
Raise a number to a power.
Return value
Number raised to power.
Syntax
=POWER (number, power)
Example:
TODAY and NOW Functions
The Excel NOW function returns the current date and time, updated
continuously when a worksheet is changed or opened. The NOW
function takes no arguments.
Syntax:
=NOW ()
The Excel TODAY function returns the current date, updated
continuously when a worksheet is changed or opened. The TODAY
function takes no arguments.
Syntax:
=TODAY ()
