Page 22 - trackpad v5.1 class 7 flipbook
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   Pro (V5.1)-VII
   17   18   19   20   21   22   23   24   25   26   27