Logical Tests
What? No No Logical formulas Comperative Operator Signs
Is 25=45? 25 45 0=
Is 24<>45? 25 45 1 <>
Is 25>45? 25 45 0>
Is 25>=45? 25 45 0 >=
Is 25<45? 25 45 1<
Is 25<=45? 25 45 1 <=
Comperative Operator names
Equal to
Not equal to
Greater than
Greater than or Equal to
Less than
less than or Equal to
Logical Functions
IF function
IF function can put one of two things in a cell
The IF function has three parts
1) Logical test
2)Value if TRUE
3)Value if FALSE
For the value "if TRUE "and the value" IF FALSE "
You can put the numbers ,Text(must be in double qoutes),formulas,or cell ranges
Sale 1 Sale 2 Pass
85 45 Fail
Answer as Formula
True,False FALSE
1,0 1
Pass,Fail Pass
PASS,FAIL FAIL
YES,NO YES
K2+L2,0 130
today(),Today+10 Saturday, December 7, 2024
Logical Function
Nested IF function
Names Marks Result
<40 Fail Yaseen 25 Fail
>40 Pass Younas 35 Fail
>60 Distination Ayaz 84 Excellent
Sudais 85 Excellent
Ilyas 46 Pass
Awais 74 Excellent
Marwan 98 Excellent
Sidra 75 Excellent
Afia 75 Excellent
Laiba 80 Excellent
Fauzia 85 Excellent
Logical Function
NOT Function
Data 1 Not
TRUE FALSE
FALSE TRUE
1 FALSE
0 TRUE
Logical Function
IF ERROR Function
Data type Data IF ERROR Function
Text Tutorial Point Tutorial Point
Number 527 527
1 TRUE TRUE
0 FALSE FALSE
Error from formula Err:509 Skip this cell
Logical Function
AND function Marks >=0
100 <=100
Criteria 1 Criteria 2 Result Names Marks Result
>=0 <40 Fail Yaseen 100 Excellent
>=40 <60 Pass Younas 40 Pass
>=60 <100 Distination Ayaz 84 Excellent
<0 >100 Invalid Sudais 85 Excellent
Ilyas 46 Pass
Awais 74 Excellent
Marwan 128 Invalid
Sidra 75 Excellent
Afia -6 Invalid
Laiba 80 Excellent
Fauzia 85 Excellent
