0% found this document useful (0 votes)
43 views4 pages

If Examples

The document contains various tables and schedules related to Batman characters including their test scores and grades, Batmobile driving schedule for June 2022, and weekly schedules. It also includes names of characters from Batman and Spider Man comics. The tables show character names, test scores, grades, attendance, driving schedules, and weekdays they are assigned tasks.

Uploaded by

gajanangaikwad6
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
43 views4 pages

If Examples

The document contains various tables and schedules related to Batman characters including their test scores and grades, Batmobile driving schedule for June 2022, and weekly schedules. It also includes names of characters from Batman and Spider Man comics. The tables show character names, test scores, grades, attendance, driving schedules, and weekdays they are assigned tasks.

Uploaded by

gajanangaikwad6
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

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

You might also like