Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 22 - 2612_Digimind
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.
                      To use the IF() function, follow the given steps:

                                                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 |