Page 20 - Trackpad_V5_Book 7
P. 20
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(number 1, number 2, number 3, ...
number n). For example, =AVERAGE (4,5,6) will be 5.
IF()
The IF() function checks a condition to evaluate 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.
18 Pro (Ver. 5.0)-VII

