Page 22 - trackpad v5.1 class 7 flipbook
P. 22
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.
20 Pro (V5.1)-VII

