Scribd
Upload
37 views3 pages

Using IF Function: Names Marks Acquired Result

The document presents the results of students based on their marks using IF, OR, and AND functions. It categorizes students as 'PASS' or 'FAIL' based on their scores in various subjects. Additionally, it includes a summary of the average marks and counts of specific results.

Uploaded by

C11Pavithra Ram
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
37 views3 pages

Using IF Function: Names Marks Acquired Result

The document presents the results of students based on their marks using IF, OR, and AND functions. It categorizes students as 'PASS' or 'FAIL' based on their scores in various subjects. Additionally, it includes a summary of the average marks and counts of specific results.

Uploaded by

C11Pavithra Ram
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

Using IF Function

Names Marks Acquired Result


Harry 32 FAIL
Gandalf 79 PASS
Hagrid 51 PASS
Hermoine 72 PASS
Hercules 27 FAIL
Abraham 57 PASS
Hulk 58 PASS
Thor 77 PASS
Batista 81 PASS
Loki 88 PASS
Using OR
Name Science Math English Social Analysis Result
Harry 63 62 73 92 0 PASS
Gandalf 67 29 41 82 1 FAIL
Hagrid 47 52 87 22 1 FAIL
Hermoine 77 26 78 75 1 FAIL
Hercules 62 26 45 22 1 FAIL
Abraham 80 71 25 71 1 FAIL
Hulk 91 74 61 52 0 PASS
Thor 27 29 35 76 1 FAIL
Batista 76 50 61 60 0 PASS
Loki 38 40 32 92 1 FAIL
Using AND
Name Science Math English Social Analysis Result
Harry 63 62 73 92 0 PASS
Gandalf 67 29 41 82 0 PASS
Hagrid 47 52 87 22 0 PASS
Hermoine 32 26 28 12 1 TRUE
Hercules 62 26 45 22 0 PASS
Abraham 80 71 25 71 0 PASS
Hulk 91 74 61 52 0 PASS
Thor 27 29 35 76 0 PASS
Batista 76 50 61 60 0 PASS
Loki 38 40 32 92 0 PASS
PASS

27
91
58
73.16667
6

You might also like