Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 88 - 2619_PlusGPT V2.1_C-7
P. 88

    FUNCTIONS

                      Functions  are predefined formulas in Google  Sheets  that  help you  perform calculations,  both
                      simple and complex. Functions take in arguments, which are the input values for the function.
                      These arguments can be numbers, text, or cell references.
                      The arguments are placed inside parentheses () after the function name.

                           Rules for Using Functions

                      There are certain set of rules that should be followed while using functions. Some of the rules are
                      given below:
                         Always start a function with the equal sign (=) followed by the function name. For example,
                         =SUM, =AVERAGE, or =MAX.

                         Functions require  arguments  (the input  values) inside  parentheses  ().  For  example,  in
                         =SUM(A1:A5), A1:A5 is the argument.
                         If the function needs more than one argument, separate them with commas. For example,
                         =IF(A1>10, "Yes", "No") has three arguments: A1>10, "Yes", and "No".
                         When using functions that work with a range (like SUM or AVERAGE), make sure the range is
                         correct. For example, =SUM(B1:B5) adds up the values from B1 to B5.
                         Arguments  can  be  numbers  (e.g., =SUM(5,  10)), text  (e.g., =CONCATENATE("Hello",  "  ",
                         "World")), or cell references (e.g., =A1+B1).

                         The function name must be typed exactly right. Google Sheets will show an error if it doesn't
                         recognise the function name (e.g., =sum won't work, but =SUM will).

                      Categories of Functions

                      The functions are divided into further categories as mentioned below:

                      Mathematical Functions
                      These functions are used to perform mathematical calculations.
                               Functions                           Purpose                            Example

                                                                                            Input: =SUM(10,10)
                       SUM(range)                   It adds the value in a given range
                                                                                            Output: 20
                                                    It multiplies the values in a range of  Input: =PRODUCT(4,2,8)
                       PRODUCT(range)
                                                    cells.                                  Output: 64

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

                                                                  Tech Fact

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

                      86    Premium Edition-VII

| 83 84 85 86 87 88 89 90 91 92 93 |