Page 21 - TrackpadV2.1_Class8
P. 21
The sum is displayed
in the active cell.
Subject: How to calculate average
To calculate the average of given numbers in defined range of cells,
enter the formula =AVERAGE(number1, number2, number3, ...
number n). For example, =AVERAGE (4,5,6) will be 5.
IF()
The IF() function checks a condition to evaluate whether it as true or false and based on the
result, suitable actions are performed. This function takes three arguments into consideration:
the condition, the value to be displayed when the condition is true, and the value to be displayed
when the condition evaluates to be false.
2 Click on the Formulas tab.
3 Click on the
Insert Function
command.
1 Select the
cell where you
want the result
to be displayed.
Advanced Features of Excel 19

