Page 27 - Trackpad_V1_Book 6_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

                                         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  Insert
                  Function option.







                   1  Select an empty
                  cell to hold the sum
                  of the numbers.
                                                                                  4  Click on
                                                                                  OK button.






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