if-function-with-several-conditions.xlsx

	B	C	D	E	F	G	H
1
2	Data and condition			Result of checking
3	Data and condition			Result of checking
4	50	more	40	TRUE
5	50	less	40	FALSE
6
7
8
9
10	А	90-100
11	B	80-89
12	C	60-79
13	D	less 60
14
15
16	Student			Grade in points	Grade in ECTS scale
17	Anna			78
18	Mark			91	A
19	Jack			87
20	Margo			79
21	Adam			96	A
22
23
24	А	90-100
25	B	80-89
26	C	60-79
27	D	less 60
28
29
30	Student			Grade in points	Grade in ECTS scale
31	Anna			78	С
32	Mark			91	А
33	Jack			87	В
34	Margo			79	С
35	Adam			96	А
36
37
38
39	А	90-100
40	B	80-89
41	C	60-79
42	D	less 60
43
44
45	Student			Grade in points	Grade in ECTS scale
46	Anna			78	С
47	Mark			91	С
48	Jack			87	С
49	Margo			79	С
50	Adam			96	С
51
52
53	59	D
54	60	C
55	80	B
56	90	A
57
58
59	Student			Grade in points	Grade in ECTS scale
60	Anna			78	C
61	Mark			91	A
62	Jack			87	B
63	Margo			79	C
64	Adam			96	A
65
66	Student			S1	S2	S3	retake
67	Anna			3	4	5	no retake
68	Mark			2	4	4	have a retake
69	Jack			5	5	4	no retake
70	Margo			4	3	2	have a retake
71	Adam			5	5	5	no retake
72	Nick			4	3	2	have a retake
73	Kate			3	3	4	no retake
74	Tim			4	4	2	have a retake
75
76
77
78	Student			S1	S2	S3	scholarship
79	Anna			3	4	5	no scholarship
80	Mark			4	4	4	have a scholarship
81	Jack			5	5	4	have a scholarship
82	Margo			4	3	3	no scholarship
83	Adam			5	5	5	have a scholarship
84	Nick			4	3	4	no scholarship
85	Kate			3	3	4	no scholarship
86	Tim			4	4	5	have a scholarship
87
88
89
90	Student			Absence	Credit
91	Anna			3	no credit
92	Mark NOT			no	get credit
93	Jack			2	no credit
94	Margo			5	no credit
95	Adam			7	no credit
96	Nick			9	no credit
97	Kate NOT			no	get credit
98	Tim NOT			no	get credit
99
100