Page 20 - Trackpad_V1_Book 7_Flipbook
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 Insert
Function option.
1 Select the
cell where you
want the result
to be displayed.
18 Trackpad (Version 1.0)-VII

