{"id":3649,"date":"2018-12-12T18:30:04","date_gmt":"2018-12-12T18:30:04","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3649"},"modified":"2024-03-26T13:07:48","modified_gmt":"2024-03-26T13:07:48","slug":"logical-operators-equal-to-not-equal-to-greater-than-less-than","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/logical-operators-equal-to-not-equal-to-greater-than-less-than\/","title":{"rendered":"Excel Logical Operators: Equal To, Not Equal To, Greater Than, Less Than"},"content":{"rendered":"\n
When you work in Excel, sometimes you may want to calculate data only if a particular condition is met. You can achieve this by using logical operators (also known as comparison operators). Excel provides six of them. This tutorial will provide you with a lot of information on how to use comparison operators inside Excel formulas.<\/p>\n\n\n\n
As I wrote at the beginning, the logical operators are also called comparison operators. But there is also another name for them – they are called Boolean operators because the result of the comparison always returns TRUE<\/strong> or FALSE<\/strong>.<\/p>\n\n\n\n They work not only with numbers but also with text and dates.<\/p>\n\n\n\n The following table shows the six operators used in Excel and describes how it works.<\/p>\n\n\n\n Here are a few examples showing comparison operators in action.<\/p>\n\n\n\nName<\/strong><\/td> Operator<\/strong><\/td> Example<\/strong><\/td> Description<\/strong><\/td><\/tr> equal to<\/td> =<\/td> A1=B1<\/td> Returns TRUE<\/strong> only if A1<\/strong> is equal to A2<\/strong><\/td><\/tr> greater than<\/td> ><\/td> A1>B1<\/td> Returns TRUE<\/strong> only if A1<\/strong> is greater than A2<\/strong><\/td><\/tr> less than<\/td> <<\/td> A1<B1<\/td> Returns TRUE<\/strong> only if A1<\/strong> is less than A2<\/strong><\/td><\/tr> greater than or equal to<\/td> >=<\/td> A1>=B1<\/td> Returns TRUE<\/strong> only if A1<\/strong> is greater or equal to A2<\/strong><\/td><\/tr> less than or equal to<\/td> <=<\/td> A1<=B1<\/td> Returns TRUE<\/strong> only if A1<\/strong> is less or equal to A2<\/strong><\/td><\/tr> not equal to<\/td> <><\/td> A1<>B1<\/td> Returns TRUE<\/strong> only if A1<\/strong> is different than A2<\/strong><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n