Project 1 — Pass/Fail System

Create:

Student

English

Maths

Science

Result

Rule

All subjects ≥ 40 → Pass

Use:

IF + AND

Project 2 — Grade Calculator

Columns:

Student | Total Marks | Percentage | Grade

Rules

  • 90+ → A+
  • 75–89 → A
  • 60–74 → B
  • 40–59 → C
  • Below 40 → Fail

Use:

IFS

Project 3 — Employee Bonus Calculator

Columns:

Employee | Sales | Performance | Bonus Status

Rule

Sales ≥ ₹1,00,000 OR Performance ≥ 90

Use:

IF + OR

Project 4 — Attendance Status

Columns:

Employee | Working Days | Present Days | Attendance % | Status

Rule

Attendance ≥ 75% → Eligible

Use:

IF

Project 5 — Eligibility Checker

Create:

Student

Age

Marks

Attendance

Eligibility

Eligibility Rules

  • Age ≥ 18
  • Marks ≥ 50
  • Attendance ≥ 75%

Use:

IF + AND

Formula

=IF(AND(B2>=18,C2>=50,D2>=75%),”Eligible”,”Not Eligible”)

Practice File

Logical_Functions_Workbook.xlsx

Include 5 worksheets:

  1. Pass_Fail
  2. Grade_Calculator
  3. Employee_Bonus
  4. Attendance
  5. Eligibility_Checker

Functions to Practice

IF • AND • OR • NOT • IFERROR • IFS • SWITCH

PreviousNext