2.1 Comparison Operators with the IF Function Let’s see how we can use them with different Excel functions to find out if an outlet is gaining profit or incurring a loss, count and sum up all the sales amount above $1000. The main use of comparison operators is in different Excel functions like IF, SUMIF, COUNTIF, Etc. Greater Than and Less Than Excel Comparison Operators in Arguments of Excel Functions We will see that it returns for cells E10 and E12 as the Sales and Expenditure values in corresponding cells are equal.Ģ.If we drag the fill handle to autofill the rest of the cells, it will return boolean values for every cell comparing the corresponding Sales and Expenditure values in the respective rows. As the Sales (C5) and Expenditure (D5) values are not equal, the conditional operators will return TRUE.We have written the below formula to compare these values.We are comparing the sales amount in cell C5 with the expenditure amount in cell D5. For example, take a look at the formula in cell E5 below.The less than operator (<) returns TRUE if the first value is less than the second value. We will use comparison operators i.e., greater than (>) and less than () returns TRUE if the first value is greater than the second value. The Excel worksheet contains sales and expenditure amounts for each of these restaurants. Let’s assume we have an Excel worksheet that contains the information of various outlets of a chain restaurant all across the United States. C# language specificationįor more information, see the Relational and type-testing operators section of the C# language specification.5 Easy Methods to Use Greater than and Less than in Excel If a type overloads one of the = operators, it must overload both =. If a type overloads one of the operators, it must overload both. The >= operator returns true if its left-hand operand is greater than or equal to its right-hand operand, false otherwise: Console.WriteLine(7.0 >= 5.1) // output: TrueĬonsole.WriteLine(5.1 >= 5.1) // output: TrueĬonsole.WriteLine(0.0 >= 5.1) // output: FalseĬonsole.WriteLine(double.NaN = 5.1) // output: FalseĪ user-defined type can overload the, = operators. The > operator returns true if its left-hand operand is greater than its right-hand operand, false otherwise: Console.WriteLine(7.0 > 5.1) // output: TrueĬonsole.WriteLine(5.1 > 5.1) // output: FalseĬonsole.WriteLine(0.0 > 5.1) // output: FalseĬonsole.WriteLine(double.NaN > 5.1) // output: FalseĬonsole.WriteLine(double.NaN 5.1) // output: False Less than operator = 5.1) // output: False The = and != operators check if their operands are equal or not. For operands of the same enum type, the corresponding values of the underlying integral type are compared. In the case of char operands, the corresponding character codes are compared.Įnumeration types also support comparison operators. The char type also supports comparison operators. For more information and examples, see the Double.NaN or Single.NaN reference article. That means that the NaN value is neither greater than, less than, nor equal to any other double (or float) value, including NaN. For the =,, = operators, if any of the operands is not a number ( Double.NaN or Single.NaN), the result of operation is false.

Greater than or equal to