EXCEL FORMULA MASTER.xlsx

	A	B	C	D	E	F	G
1	Compound Interest Calculation
2	Principal	100			lower	UPPER	Proper
3	Rate	2.25		RamesH	ramesh	RAMESH	Ramesh
4	Interest	4		Dinesh	dinesh	DINESH	Dinesh
5	Compound Int	109.3083319		Nandu	nandu	NANDU	Nandu
6				Madan	madan	MADAN	Madan
7	Simple Interest	9
8
9
10	Name	Marks	Result		Vlookup	Marks	Result
11	Ramesh	56	Pass		Ramesh	56	Pass
12	Dinesh	45	Fail		Nandu	53	Pass
13	Nandu	53	Pass		Nisha	45	Fail
14	Madan	80	Pass		Nandu	53	Pass
15	Nisha	45	Fail
16	Ganesh	36	Fail
17	Sohan	48	Fail		Current Date		12/7/2025
18	Mukul	47	Fail		Current Date and Time		12/7/25 7:29
19	Anuj	71	Pass
20	Anil	23	Fail		Formula used		Location of Cell, where used
21	Ravi	44	Fail		Compound Int		B5
22	Mayank	52	Pass		Simple Interest		B7
23					Lower		E3:E6
24					Upper		F3:F6
25	Formula				Proper		G3:G6
26	Count	12			If		C12:C23
27	Counta	12			Conditional Formatting		C12:C23
28	Average Marks	50			Vlookup		F12:F15, G12:G15
29	Highest Marks	80			Current Date		G18
30	Minimum Marks	23			Current Date and Time		G19
31	Pass	5			Count		B27
32	Fail	7			Counta		B28
33	Total	12			Average Marks		B29
34					Highest Marks		B30
35					Minimum Marks		B31
36					Countif		B32, B33
37					Sum		B34
38
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