Assignment 12 Logical Function Result with different phase

 

Assignment 12

Logical Function

Result with different phase

Function Use

AND :- This is a logical function which return "TRUE" or "FALSE" it will check logic till "TRUE".

OR :- This is a logical function which return "TRUE" or "FALSE" it will check logic till "FALSE".

Function for Phase 1

Criteria :- If the person pass in all subject then "Pass" otherwise "Fail".

=AND(C4>=50,D4>=50,E4>=50)

AND function check the whole criteria if the three cell value is greater than or equal to 50 then it must be print "TRUE" otherwise "FALSE"

Function for Phase 2

Criteria :- If the person Pass in any one subject then "Pass" otherwise "FALSE"

=OR(C4>=50,D4>=50,E4>=50)

OR function check the criteria if there are any one cell value greater than or equal to 50 in that cells then it must be print "TRUE" otherwise "FALSE"

Function for Phase 3

Criteria :- If the person Pass in minimum two subjects then "Pass" otherwise "FALSE"

=OR(AND(C4>=50,D4>=50),AND(D4>=50,E4>=50),AND(E4>=50,C4>=50))

In that function print the "TRUE" value if the person is pass minimum two subject otherwise "FALSE"

Note

There are 3 subjects English, Computer, Math and marks obtain is also given on the basic of that marks try to find the result pass of fail by follow the criteria (Phase).

This assignment is divided into three phase and the criteria of all phase are given in he passing marks in "50"

Insert the function in the yellow color highlighted cell for print the result pass r fail.