The not equal to operatorreturns FALSE if the two values are identical, and TRUE otherwise. The equal to operator returns TRUE if the two values being compared are identical, and FALSE otherwise. ![]() The equal to (=) and not equal to () operators These operators are simple: they tell you whether two values are equal or not equal to each other. Got a different version? No problem, you can still follow the exact same steps.Ĥ: Greater than (>) and less than (=) and less than or equal to () *This tutorial is for Excel 2019/Microsoft 365 (for Windows). Lets take a look at each one of these operators, and then see how you can use them with the IF function. These comparison operators return a TRUE or FALSE value that can be used with logical functions to give you even more options. ![]() Statements like greater than, less than or equal to, and not equal to can be very useful when youre analyzing data. Most of the operators you use in Excel are probably mathematical, like +, -, *, and /.īut theres another set of useful operators: the logical operators. Written by co-founder Kasper Langmann, Microsoft Office Specialist. ![]() Equal to, Not equal to, Greater than, Less than (+much more)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |