Page 50 - KEC Khaitan C6 Flipbook
P. 50

4  Select the Math & Trig option from the
                       Or select a category drop-down list.             7  To calculate the sum of numbers
                                                                       in cells C2 to H2, the range must be
                                                                       specified as C2:H2 in the Number1 box.













                     5  Select the SUM function.




                                     6  Click on the OK button.                               8  Click on the OK button.















                                                                                   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.





                   48   Premium Edition-VI
   45   46   47   48   49   50   51   52   53   54   55