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