Logical Operators in Excel - How to Compare Things #pdf
1089 times
21 KB
Rating:
5
5Download Other files in Community & General category
File Content -
Logical Operators in Excel - How to Compare Things
List of Logical Operators
Condition Operator Description Simple Usage Example
Equal to = Checks if a value is equal to
another value.
=1=5
(checks if 1 is equal to 5 - result will
be FALSE)
Not equal to <> Check if a value is NOT equal to
another value.
=1<>5
(checks if 1 is NOT equal to 5 -
result will be TRUE)
Greater than > Check if a value is greater than
another value.
=1>5
(checks if 1 is greater than 5 -
result will be FALSE)
Less than < Check if a value is less than
another value.
=1<5
(checks if 1 is less than 5 - result
will be TRUE)
Greater than or
equal to
>= Check if a value is greater than OR
equal to another value.
=1>=5
(checks if 1 is greater than or equal
to 5 - result will be FALSE)
Less than or
equal to
<= Check if a value is less than OR
equal to another value.
=1<=5
(checks if 1 is less than or equal to
5 - result will be TRUE)
Comments
Trending Downloads
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
