Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 39 - logicode 2609 C6
P. 39

    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.

                                                                                        Advanced Features of Excel 2021   37

| 34 35 36 37 38 39 40 41 42 43 44 |