Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 31 - 2632_CodeMind
P. 31

    Suppose you could use Excel to set and track your personal goals. What goals would you
                                        set, how would you measure your progress, and how would you use charts to visualise your
                                        achievements?

                      Mathematical Functions

                       Function                    Purpose                              Example

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

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

                                                   It  returns  the  remainder  after  a   Input: =MOD(8,5)
                       MOD(number, divisor)
                                                   number is divided by the divisor.    Output: 3

                                                   It  returns  the  square  root  of  the   Input: =SQRT(81)
                       SQRT(number)
                                                   given number.                        Output: 9

                                                   It  removes  the  decimal  part  of  Input: =INT(14.25)
                       INT(number)                 the  number  and  returns  only  the   Output: 14
                                                   integer part.

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

                       ROUND(number,               It returns a number after rounding   Input: =ROUND(35.666,2)
                       number_of_digits)           to the specified digits.             Output: 35.67

                                                   It returns the absolute value of a   Input: =ABS(-25)
                       ABS(number)
                                                   given number.                        Output: 25

                                      In functions, we can also use the cell address in place of the values.

                          30     Premium Edition-VI

| 26 27 28 29 30 31 32 33 34 35 36 |