Page 28 - KEC Khaitan C6 Flipbook
P. 28

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.






                   26   Premium Edition-VI
   23   24   25   26   27   28   29   30   31   32   33