Day 9 - IF & OR, Nested IF.xlsx

	B	C	D	E	F	G	H	I	J	K
1
2	IF						IF, AND
3
4	CA Final						CA Final
5
6	Group 1						Group 1
7	Sl. No	Subject	Max. Marks	Marks obtained			Sl. No	Subject	Max. Marks	Marks obtained
8	1	Financial Reporting	100	40			1	Financial Reporting	100	55
9	2	Strategic Financial Management	100	50			2	Strategic Financial Management	100	50
10	3	Audit	100	60			3	Audit	100	50
11	4	Corporate Law	100	40			4	Corporate Law	100	50
12	Total		400	190			Total		400	205
13	Pass/ Fail		Fail				Pass/ Fail		Pass
14
15			IF(E12>=200,"Pass","Fail")				IF(AND(K8>=40,K9>=40,K10>=40,K11>=40,K12>=200),"Pass","Fail")
16			IF(E12<200,"Fail","Pass")
17	Group 2						Group 2
18	Sl. No	Subject	Max. Marks	Marks obtained			Sl. No	Subject	Max. Marks	Marks obtained
19	1	Costing	100	50			1	Costing	100	50
20	2	Open Book	100	60			2	Open Book	100	60
21	3	Direct Tax	100	70			3	Direct Tax	100	70
22	4	Indirect Tax	100	40			4	Indirect Tax	100	40
23	Total		400	220			Total		400	220
24	Pass/ Fail		Pass				Pass/ Fail		Pass
25
26			IF(E23>=200,"Pass","Fail")				IF(AND(K19>=40,K20>=40,K21>=40,K22>=40,K23>=200),"Pass","Fail")
27			IF(E23<200,"Fail","Pass")
28
29
30
31
32
33
34
35
36				AND
37
38				CA Final
39
40				Group 1
41				Sl. No	Subject	Max. Marks	Marks obtained
42				1	Financial Reporting	100	55
43				2	Strategic Financial Management	100	35
44				3	Audit	100	40
45				4	Corporate Law	100	40
46				Total		400	170
47				Checking "AND" Condition		FALSE
48
49
50					AND(H42>=40,H43>=40,H44>=40,H45>=40)
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