Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 21 - 2617_JSSPS_C-6
P. 21

    Functions                             Purpose                                   Example
                                          It returns the count of the number of values in the    Input: =COUNT(4,8,12)
                     Count(range)
                                          selected range.                                        Output: 3
                     ROUND(number,        It returns a number after rounding to the specified    Input: =ROUND(35.666,2)
                     number_of_digits)    digits.                                                Output: 35.67

                                                                                                 Input: =ABS(–25)
                     ABS(number)          It returns the absolute value of a given number.
                                                                                                 Output: 25
                                                                                                 Input: =MAX(4,16,12,9)
                     Max(range)           It returns the largest value in the given range.
                                                                                                 Output: 16

                                                                                                 Input: =MIN(4,16,12,9)
                     Min(range)           It returns the smallest value in the given range.
                                                                                                 Output: 4
                                          It returns the average of the given numbers in a       Input: =AVERAGE(12,3,6)
                     Average(range)
                                          range.                                                 Output: 7

                                Factbot

                           In functions, we can also use the cell address in place of the values.

                     Perform the following steps to use the mathematical functions:

                     When you press the Enter key, the price of the pencils appears in cell D3. Using the AutoFill feature,
                     we can calculate the prices of the Geometry Boxes and Pens.

                                                                                           To calculate the price
                             Type the given                                                of Pencils, type the
                         1   data in the Excel                                             =PRODUCT(B3:C3) function    2
                             worksheet.                                                    and press Enter key.

                                                                                                          Calculate
                                                                                                          the Tax by
                                                                                                          using the
                                                                                                          =(D6*7)/100   4
                                                                                                          formula.

                            To calculate the subtotal, type the              Calculate  the  Total  by
                        3   =SUM(D3:D5) function and press               5   using the =SUM(D6:D7)
                            Enter key from the keyboard.                     function.

                                                                                 Charts, Formulas & Functions in Excel  19

| 16 17 18 19 20 21 22 23 24 25 26 |