FUNCTIONS

Mathematical functions

SumSum( ):- This function returns the sum of numeric values of a cell range.
Syntax: = Sum (C20:C40)↩
 Average: - This function returns the average of a numeric cell range.
Syntax: = AVERAGE(C20:C40) ↩
 Max( ):- This function returns the largest number from a numeric cell range.
Syntax: = Max (C20:C40) ↩
 Min( ):- The function returns the smallest number from a numeric cell range.
Syntax: = Min (C20:C40) ↩
 Count( ):- This function counts the total number of cells from a numeric cell range.
Syntax: = COUNT(C20:C40) ↩
 COUNTA( ): - This function returns the total number of cells from a cell range which contains value.
Syntax: =COUNTA(C20:C40) ↩
 COUNTBLANK ( ):- This function counts the total no. of cells from a cell range which is empty.
Syntax: = COUNTBLANK(C20:C40)↩ 

Text functions

 Left( ) – This function returns the specified characters from left side of the text string.
Syntax- =left(“computer”,5)↩
Right( ) - This function returns the specified characters from the right side of the text string
Syntax- =right(“computer”,5) ↩
 Mid( ) – This function returns the middle characters from the left as well as right from the text string.
Syntax- =mid(“computer”,4,3) ↩
 Rept( ) – This function repeats a string to specified no. of characters.
Syntax- =rept(“sterliate”,5) ↩
 Proper( ) – This function converts a text string into title case.
Syntax- =proper(“sterliate”) ↩
 Upper( ) – This function converts a text string into UPPER case.
Syntax- =upper(“sterliate”) ↩
 Lower( ) – This function converts a text string from upper case to lower case.
Syntax- =lower(“STERLIATE”) ↩
Date & Time Function
 Now() – This function returns today’s date and current time.
Syntax- =now()↩
 Day (): This function returns the no. of days from a specified date.
Syntax:- = Day (“12/02/2005”) ↩
Month():- This function returns the no. of months from the specified date.
Syntax:- =Month (“07/24/2009”) ↩
 Year():- This function returns the year from a specified date.
Syntax: - =year(“04/08/2008”)↩
 LOGICAL FUNCTION
 IF():- This function returns a value based on a specified criteria. It returns another output when the criteria is not fulfilled.
Syntax:- = IF (criteria, value If criteria is true, value if criteria is false) ↩
Example:

 SUMIF():- This function returns the sum of a numeric cell range based on criteria.
Syntax:- =SUMIF(check range, criteria, sum range) ↩
COUNTIF():- This function returns the total no. of cells from a cell range based on criteria.

FINANCIAL FUNCTIONS
 PMT():- This function returns the installment of a loan amount paid periodically at a constant interest rate for a certain period.
Syntax:- = PMT(Rate/condition, no of terms, loan amount) ↩
Example:- = PMT( 11%/12 ,60,100000) ↩
Output- 2174.24
Santosh Kumar Singh