Page 27 - Trackpad_V2.1_Class6
P. 27

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



                        Function                           Purpose                               Example



                                         It returns the sum of numbers, specific cell  Input: =SUM(4,8,12,16)
                  SUM(range)
                                         references, ranges of cells.                   Output: 40

                                         It  multiplies  numbers,  cell values,  and  Input: =PRODUCT(4,2,8)
                  PRODUCT(range)
                                         ranges.                                        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
                                         It returns the count of the number of values  Input: =COUNT(4,8,12)
                  COUNT(range)
                                         in the selected range.                         Output: 3
                  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