Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 22 - 2633 Trackpad Pro V5.1 Class 7
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   Premium Edition-VII

| 17 18 19 20 21 22 23 24 25 26 27 |