WHAT IS THE LOGICAL TEST
A LOGICAL TEST IS ANY VALUE OR EXPRESSION THAT CAN BE EVALUATED AS EITHER TRUE OR FALSE.
A logical test usually consists of three parts:
1. A cell reference
2. A comparison calculation operator, that is…
less than (<) greater than or equal to (>=)
less than or equal to (<=)
not equal to (<>)
equal to(=)
3. A value, text, cell reference or formula
WHAT IS THE COMPARISON OPERATOR
Two values compared by using these, the result is true or false
Written Out..
= (EQUAL SIGN) A1=B1
> (GREATER THAN SIGN) A1>B1
< (LESS THAN SIGN) A1= (GREATER THAN OR EQUAL TO SIGN) A1>=B1
<= (LESS THAN OR EQUAL TO SIGN) A1<=B1
<> (NOT EQUAL TO SIGN) A1<>B1
No Comments