IF & 5 Adv.
Tips
Student Score Pass / Fail? Grade GRADE 2
Batman 80 Pass B B
Robin 75 Pass C C
Barbara G 94 Pass A A
James G 45 Fail D D
Alfred 42 Fail D D
Scroll down for more examples
Student Score Attendance Pass / Fail?
Batman 80 70% Pass
Robin 75 50% Fail
Barbara G 94 25% Fail
James G 45 80% Pass
Alfred 42 100% Pass
Batmobile Driving Schedule - June 2022
Date Who Who 2
1-Jun-22 Robin Robin
2-Jun-22 Barbara G Barbara G
3-Jun-22 Batman Batman
4-Jun-22 Robin Robin
5-Jun-22 Batman Batman
6-Jun-22 James G James G
7-Jun-22 Batman Batman
8-Jun-22 Robin Robin
9-Jun-22 Barbara G Barbara G
10-Jun-22 Batman Batman
11-Jun-22 Robin Robin
12-Jun-22 Batman Batman
13-Jun-22 James G James G
14-Jun-22 Batman Batman
Person chandoo Name
Bruce Wayne
Comic #NAME? Robin
Barbara G
James G
Alfred
Name
Peter Parker
Green Goblin
Vulture
Mary Parker
Mary Jane
Click for more on IF
IF formula - 10 ADVANCED Examples
SUMIFS formula - 10 ADVANCED Examples
15 Must know Excel Functions
Weekday Person
Monday James G
Tuesday Batman
Wednesday Robin
Thursday Barbara G
Friday Batman
Saturday Robin
Sunday Batman
Comic
Batman
Batman
Batman
Batman
Batman
Comic
Spider Man
Spider Man
Spider Man
Spider Man
Spider Man