Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 36 - ClickGPT V4.0 C-5
P. 36

    Functions                              Purpose                                   Example
                   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.

                     34     Premium Edition-V

| 31 32 33 34 35 36 37 38 39 40 41 |