Logical
Logical
TRUE-1
AND
ALL COND MUST BE TRUE FALSE-0
COND1 COND2 RESULT
4YRS 0 0 FALSE FALSE
MASTERS 0 1 FALSE
1 0 FALSE
1 1 TRUE FALSE
TRUE
N>0 TRUE
ANY
OROF COND MUST BE TRUE N<0 TRUE
COND1 COND2 RESULT N==0 FALSE
0 0 FALSE
0 1 TRUE
1 0 TRUE
1 1 TRUE
PROBLEM
SOLUTION NESTED IF
NOT ELIGIBLE
45 #N/A
NOT XOR BOTH OF THE COND MUST BE DIFF
TRUE=FALSE
FALSE=TRUE COND1 COND2
0 0
0 1
1 0
1 1
90
IF NO
X
NESTED IF FOUR
A
B
C
D
RESULT
FALSE
TRUE
TRUE
FALSE
NAME MARK RESULT
DENNIS 12 A GRADE a
JAMES 78 C GRADE
JHONNY 67 C GRADE
TIM 45 B GRADE
BILL 34 A GRADE