Logical Operators in Excel - How to Compare Things #pdf
1089 times
21 KB
Rating:
5
5File 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
Tax Comparison Calculator under New Tax Regime as per Finance Bill 2025
On : 12 February 2025Download
Trending Online Classes
-
PF & ESI Course - Labour Code 2019 Along with Examples and Case Studies
Mr.Balamurugan Ranganathan13 March 2025
Popular Files
- Income Tax Bill 2025
- Income Tax Calculator in Excel for AY 2026-27
- New Tax Regime - Exemptions and Deductions
- TDS Amendment - Budget 2025
- Tax Comparison Calculator under New Tax Regime as per Finance Bill 2025
- Automatic Form 16 Part A&B in Excel for FY 2024-25
- FAQs On New Income Tax Bill 2025
- Drafting Appearance and Pleading
- ICAI (Aggregation of LLPs) Guidelines, 2024
- ICAI (Merger and Demerger of CA Firms) Guidelines, 2024
CAclubindia
