PRACTICALS-EXERCISE 3-IF FUNCTION , SUMIF,AVERAGEIF,COUNTIF,IF,AND

 👲The SUMIF Function

Syntax

👉SUMIF(range,criteria,sum_range)

Range is the range of cells where Excel searches for the criteria that you want to be evaluated.

 Cells in each range must be numbers or names, arrays, or references that contain numbers. 

Blank and text values are ignored.

Criteria are the criteria in the form of a number, expression, or text that defines

which cells will be added. For example, criteria can be expressed as 32, "32", ">32",

or "apples".

Sum_range are the actual cells to add if their corresponding cells in range match

criteria. If sum_range is omitted, the cells in range are both evaluated by criteria

and added if they match criteria.

Note: The SUMIF function can be read as:

“Sum or add up sum_range if range meets criteria.”

The AVERAGEIF Function

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

👉Syntax

AVERAGEIF(range,criteria,average_range)

Range is one or more cells to average, including numbers or names, arrays, or

references that contain numbers.

Criteria is the criteria in the form of a number, expression, cell reference, or text

that defines which cells are averaged. For example, criteria can be expressed as 32,

"32", ">32", "apples", or B4.

Average_range is the actual set of cells to average. If omitted, range is used.

Note: The AVERAGEIF function can be read as:

“Average average_range if range meets criteria.”

The COUNTIF Function

Counts the number of cells within a range that meet the given criteria.

👉Syntax: COUNTIF(range,criteria)

Range is one or more cells to count, including numbers or names, arrays, or

references that contain numbers. Blank and text values are ignored.

Criteria is the criteria in the form of a number, expression, cell reference, or text

that defines which cells will be counted. For example, criteria can be expressed as

32, "32", ">32", "apples", or B4.

Note: The COUNTIF function can be read as:

“Count frequency or number of times or cells if range contains criteria.”

Remark

You can use the wildcard characters, question mark (?), and asterisk (*), in

criteria. A question mark matches any single character; an asterisk matches any

sequence of characters. If you want to find an actual question mark or asterisk,

type a tilde (~) before the character.

The IF Function

Returns one value if a condition you specify evaluates to TRUE and another value if

it evaluates to FALSE.

Syntax

👉IF(logical_test,value_if_true,value_if_false)

Logical_test is any value or expression that can be evaluated to TRUE or FALSE.

 For  example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the

expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE.

Value_if_true is the value that is returned if logical_test is TRUE.

Value_if_false is the value that is returned if logical_test is FALSE.

Note: The IF function can be read as:

“If Logical_test then Value_if_true otherwise Value_if_false”

The AND Function

Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument

is FALSE.

Syntax

👉AND(logical1,logical2, ...)

Logical1, logical2, ... are 1 to 255 conditions you want to test that can be either

TRUE or FALSE.