Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 27 - 2615_KEC
P. 27

    Let’s discuss the categories of function.

                     MATHEMATICAL FUNCTIONS
                     Some mathematical functions with their examples are given below:

                            Function                          Purpose                                Example

                                                                                            Input: =SUM(4,8,12,16)
                      SUM(range)             It returns the sum of a range.
                                                                                            Output: 40

                                                                                            Input: =PRODUCT(4,2,8)
                      PRODUCT(range)         It multiplies the values in a range of cells.
                                                                                            Output: 64
                      MOD                    It returns the  remainder  after a number  is  Input: =MOD(8,5)
                      (number, divisor)      divided by the divisor.                        Output: 3
                                                                                            Input: =SQRT(81)
                      SQRT(number)           It returns the square root of the given number.
                                                                                            Output: 9

                                                                                            Input: =INT(14.25)
                      INT(number)            It rounds the number to an integer value.
                                                                                            Output: 14

                      POWER                  It  returns the  result  of  a  number  raised  to  Input: =POWER(5,3)
                      (number, power)        some power.                                    Output: 125

                      ROUND(number,          It  returns a  number  after rounding  to  the  Input: =ROUND(35.666,2)
                      number of digits)      specified digits.                              Output: 35.67

                                                                                            Input: =ABS(–25)
                      ABS(number)            It returns the absolute value of a given number.
                                                                                            Output: 25

                     Let us understand this by taking an example of the SUM( ) function. Perform the following steps:

                                                      2  Click on Formulas tab.

                       3  Click on the
                      Insert Function
                      command.

                       1  Select an                                                                        4  Select SUM
                      empty cell to                                                                       in the Select a
                      hold the sum of                                                                     Function List.
                      the numbers.

                                                                                                           5  Click on the
                                                                                                          OK button.

                                                                                     Formulas and Functions in Excel 2021  25

| 22 23 24 25 26 27 28 29 30 31 32 |