Page 84 - TGPT_V5.0_C5_Flipbook
P. 84
FUNCTIONS
Functions are predefined formulas in Excel to perform both simple and complex calculations. They
accept arguments and return values. Arguments are input to the functions. These arguments can
be numbers or text. The values should be given in between opening and closing ( ) parenthesis.
Rules for Using Functions
Rules for using Functions are:
All Excel functions must begin with = sign.
Function name must be a valid Excel name.
Function must be followed by opening and closing parenthesis.
Most of the functions must contain an argument within it.
Categories of Functions
Excel provides many categories of functions.
Let us discuss some of these categories in detail.
Mathematical Functions
Mathematical functions are used to solve mathematical values.
Functions Purpose Example
Input: =SUM(D3:D7)
sum(range) It returns the sum of a range.
Output: 6590
Input: =PRODUCT(B4:C4)
Product(range) It multiplies the values in a range of cells.
Output: 1350
It returns the count of the number of values in Input: =COUNT(D3:D7)
Count(range) the selected range. Output: 5
Input: =MAX(B3:B7)
Max(range) It returns the largest value in the given range.
Output: 1500
Input: =MIN(C3:C7)
Min(range) It returns the smallest value in the given range.
Output: 1
Factbot
In functions, we can also use the values in place of the cell range.
82 Premium Edition-V

