Scribd
Upload
7 views11 pages

IFS Function

The document provides an overview of a dataset containing student examination records, including their names, marks, and grades. It also demonstrates the use of the IFS function to calculate grades based on marks and to determine pass or fail status in multiple subjects. Additionally, it includes employee data with joining and resigning dates, along with their working days and employment status.

Uploaded by

SHAHID RAHMAN
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
7 views11 pages

IFS Function

The document provides an overview of a dataset containing student examination records, including their names, marks, and grades. It also demonstrates the use of the IFS function to calculate grades based on marks and to determine pass or fail status in multiple subjects. Additionally, it includes employee data with joining and resigning dates, along with their working days and employment status.

Uploaded by

SHAHID RAHMAN
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

Overview of Dataset

Student Examination Record


Name Marks Grade
Angela Austin 73 A
Natasha Marlo 68 A-
Peter Boon 89 A+
Kevin Hick 91 A+
Richard Simpson 62 A-
verview of Dataset

Formula

=IFS(C9>=80,"A+",C9>=70,"A",C9>=60,"A-")
=IFS(C10>=80,"A+",C10>=70,"A",C10>=60,"A-")
=IFS(C11>=80,"A+",C11>=70,"A",C11>=60,"A-")
=IFS(C12>=80,"A+",C12>=70,"A",C12>=60,"A-")
=IFS(C13>=80,"A+",C13>=70,"A",C13>=60,"A-")
Apply IFS Function with Multiple Conditions

Student Name Mathematics Grade


Angela Austin 63 C
Natasha Marlo 55 F
Peter Boon 69 C
Kevin Hick 77 B
Richard Simpson 91 A
<< Try Yourself >>

Student Name Mathematics


Angela Austin 63
Natasha Marlo 55
Peter Boon 69
Kevin Hick 77
Richard Simpson 91
self >>

Grade
Utilize IFS Function to Calculate PASS and FAIL

Student Securing Marks


PASS or FAIL
Name Mathematics Physics Chemistry
Angela Austin 63 60 62 PASS
Natasha Marlo 55 92 95 FAIL
Peter Boon 69 61 60 PASS
Kevin Hick 77 89 91 PASS
Richard Simpson 91 99 59 FAIL
<< Try Yourself >>

Student Securing Marks


Name Mathematics Physics Chemistry
Angela Austin 63 60 62
Natasha Marlo 55 92 95
Peter Boon 69 61 60
Kevin Hick 77 89 91
Richard Simpson 91 99 59
PASS or
FAIL
Use IFS Function with Dates

Employee Name Joining Date Resigning Date Working Days


Angela Austin 5-Jan-13 19-Dec-21 3270.00
Natasha Marlo 10-Dec-14 15-May-20 1983.00
Peter Boon 26-Mar-12 2-Jun-19 2624.00
Kevin Hick 5-Aug-16 10-Dec-21 1953.00
Richard Simpson 9-Sep-12 25-Mar-20 2754.00
s << Try

Status Student Name


Permanent Angela Austin
Probationary Natasha Marlo
Qualified Peter Boon
Probationary Kevin Hick
Qualified Richard Simpson
<< Try Yourself >>

Joining Resigning Working


Status
Date Date Days
5-Jan-13 19-Dec-21 3270.00
10-Dec-14 15-May-20 1983.00
26-Mar-12 2-Jun-19 2624.00
5-Aug-16 10-Dec-21 1953.00
9-Sep-12 25-Mar-20 2754.00

You might also like