Use of Mathematical and Logical Function in Microsoft Excel -

Mathematical Function:

There are following type of mathematical function which is mostly used in Microsoft excel:

Sum
Count
Max
Min
Average

Use of Sum Function:

Sum function is used to find addition of selected number.
Syntax: SUM(number1, number2, ...)
If the table is -

Result = 22 in cell A6

Or

If we will write =sum (a2, a3, a4,a5) in cell A6 then it will also gives the same result.

Or

= (a1+a2+a3) also gives the same result.

Use of Count Function:

Count function is used to find number of entries in selection.
Syntax: COUNT (value1,value2,...)
If the table is -

Result = 4 in the Cell A6.

Or

If we will write =count (a2, a3, a4,a5) in the cell A6 , it will also gives the same result.

Use of Max Function :

Gives the largest number from the list of numbers.
Syntax: MAX(number1, number2,...)
If the table is -

Result = 8 in the cell A6.

Or

If we will write =max (a2, a3, a4, a5) , it will also gives the same result.

Use of Min Function :

Gives the smallest number from the list of numbers.
Syntax: MIN (number1,number2,...)
If the table is

Result = 2 in the cell A6

Or

If we will write =min (a2, a3, a4, a5),it will also gives the same result.

Use of Average Function:

Gives the average (arithmetic mean) of the numbers.
Syntax: AVERAGE(number1,number2,...)

If the table is:

Result=5.5 in the cell A6.

Or

If we will write =Average (a2, a3, a4, a5) Then it will also gives the same result.

Logical Function:

There are following type of logical function mostly used in microsoft excel.
AND
OR
NOT
IF
TRUE
FALSE

Use of AND Function:

This function gives the result TRUE if all its arguments are TRUE; gives FALSE if one or more argument is FALSE.
Syntax:   AND (logical1,logical2, ...)
If the table is :

Result = TRUE in the cell A3 because both the condition within AND function gives the result true.
And if the table is-

Result = FALSE because second condition is false ( A1 in not greater than 100).

Use of OR Function:

This function gives the result TRUE if at least one argument is
TRUE; gives FALSE if all arguments are FALSE.
Syntax:   OR (logical, logical2 ...)
If the table is:

Use of NOT Function:

Reverses the value of its argument.
Syntax
NOT (logical value)
Logical value is a value or expression that can be either TRUE or
FALSE.
If the table is

Result = TRUE in the cell A3 because value within not function gives the result FALSE.

Use of IF Function:

If function is used to test condition.
Syntax :
IF (logical condition, if logical condition true, if logical condition false)

Result=ABC in the cell A3 because logical condition is true.

Use of TRUE Function:

Returns the logical value TRUE.
Syntax :
TRUE ( )

Use of FALSE Function:

Returns the logical value FALSE.
Syntax
FALSE ( )