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
   15   16   17   18   19   20   21   22   23   24   25