Page 88 - 2619_PlusGPT V2.1_C-7

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