Page 31 - Computer Genius Class 06
P. 31

Mathematical Functions


                          Functions                        Purpose                 Example

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

                                              It multiplies the values in a range   Input: =PRODUCT(4,2,8)
                  PRODUCT(range)
                                              o  cells.                            Output: 64

                                              It returns the remainder  after  a   Input: =MOD(8,5)
                  MOD(number, divisor)
                                              num er is di ided  y the di isor.    Output: 3
                                              It returns the square  root  of the   Input: =SQRT(81)
                  SQRT(number)
                                              gi en num er.                        Output: 9

                                              It rounds the number to an integer  Input:    T 1 .2
                  INT(number)
                                               alue.                               Output: 14

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

                                              It returns the count of the number   Input: =COUNT(4,8,12)
                  COUNT(range)
                                              o   alues in the selected range.     Output: 3

                  ROUND(number, number_ It returns a number after rounding         Input:          .    2
                  of_digits)                  to the specified digits.             Output:   .


                                              It returns the absolute value of a   Input:       2
                  ABS(number)
                                              gi en num er.                        Output: 25
                  et us use the mathematical  unctions in   cel. To use the mathematical  unctions   ollo  the gi en steps
















                          1  Type the following
                          data in  the  Excel
                           or sheet.








                                                           2   To  calculate  the  price  of  Pencils,  type the
                                                          =PRODUCT(B3:C3) function and press the Enter  ey.



                                                                              Formulas and Functions in Excel  29
   26   27   28   29   30   31   32   33   34   35   36