Page 27 - Chinmaya_C6_flipbook
P. 27

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

                                         It  returns  the  square  root  of the  given  Input: =SQRT(81)
                  SQRT(number)
                                         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

                                         It returns the  absolute  value of a given  Input: =ABS(–25)
                  ABS(number)
                                         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 empty
                   cell to hold the sum
                   of the numbers.




                                                                                 4  Click on the
                                                                                 OK button.






                                                                                 Formulas and Functions in Excel 2016  25
   22   23   24   25   26   27   28   29   30   31   32