Important Functions- Excel.xlsx

	B	C	D	E
1
2	SL	FUNCTION	CATEGORY	DESCRIPTION
3	1	AND	Logical	Checks for conditions and returns TRUE if all the conditions are TRUE else FALSE if any FALSE
4	2	OR	Logical	Checks for conditions and returns TRUE if any of the conditions are TRUE else FALSE if all FALSE
5	3	COUNT	Statistical	Count number of cells in a Range that contain numbers
6	4	COUNTA	Statistical	Count number of cells in a Range that are non-empty
7	5	COUNTBLANK	Statistical	Count number of cells in a Range that are empty
8	6	COUNTIF	Statistical	Returns the count of cells based on single criteria
9	7	COUNTIFS	Statistical	Returns the count of cells based on multiple criteria
10	8	SUMIF	Statistical	Calculates the SUM of cells based on single criteria
11	9	SUMIFS	Statistical	Calculates the SUM of cells based on multiple criteria
12	10	AVERAGEIF	Statistical	Calculates the AVERAGE (arithmetic mean) of cells based on single criteria
13	11	AVERAGEIFS	Statistical	Calculates the AVERAGE (arithmetic mean) of cells based on multiple criteria
14	12	MAX	Statistical	Get the highest number in a range of cells
15	13	MIN	Statistical	Get the lowest number in a range of cells
16	14	LARGE	Statistical	Returns the nth highest number in a range
17	15	SMALL	Statistical	Returns the nth lowest number in a range
18	16	CONCATENATE	Text	Join or combine multiple text
19	17	LEN	Text	Count number of characters in a text
20	18	UPPER	Text	Convert a text to CAPITAL LETTERS
21	19	LOWER	Text	Convert a text to small letters
22	20	PROPER	Text	Convert a text to Title Case where first letter is capital and rest are small
23	21	VLOOKUP	Lookup & Reference	Lookup & return data from a vertical table by matching on the first column in the source table
24	22	HLOOKUP	Lookup & Reference	Lookup & return data from a horizontal table by matching on the first row in the source table
25	23	IF	Logical	Checks a condition and returns one value for a TRUE result, and another for a FALSE result
26	24	IFERROR	Logical	Used to handle errors in a formula
27	25	DATEDIF	Date & Time	Calculates difference between two dates in a variety of different units, such as years, months, days
28	26	SUBTOTAL	Mathematical	Returns the subtotal in a range and majorly used to perform calculations based on filters
29	27	MATCH	Lookup & Reference	Finds the position of an data in a range
30	28	INDEX	Lookup & Reference	Returns the value from range using row and column numbers
31	29	NETWORKDAYS	Date & Time	Used to calculate the number of working days between 2 dates
32	30	NETWORKDAYS	Date & Time	Used to calculate the number of working days between 2 dates - Customized
33	31	TEXT	Text	Used to convert a data from one format to specific number format
34	32	EXACT	Text	Performs a CASE-SENSITIVE comparion between 2 text and returns TRUE or FALSE
35	33	RIGHT	Text	Extract number of characters from Right Side
36	34	LEFT	Text	Extract number of characters from Left Side
37	35	MID	Text	Extract number of characters from Middle
38	36	FILTER	Lookup & Reference	Search and Filter the Range
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100