Page 20 - Chinmaya_C7_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 the
                    Insert Function
                    command.



                                                                                                       1  Select the
                                                                                                      cell where you
                                                                                                      want the result
                                                                                                      to be displayed.










                   18   Premium Edition-VII
   15   16   17   18   19   20   21   22   23   24   25