=A1>=(B1*2) Returns True if a number value in cell A1 is greater than or equal to the value of B1*2, FALSE if they are not. Let’s see the below excel if formula with greater than operator: Formula example Description =A1>10 Returns True if a number value in cell A1 is greater than 10, FALSE if they are not. And if the first letters are same, it will compare the second letters and so on. Those excel comparison operators mostly used to compare numbers, date and time values.Īlso, we can use those operators to compare text string, and it will compare the value of the first letters in the text string. The “ Less than or equal to” operator returns TRUE if the first value in cell is smaller than the second of the two values are equal. The “ Less than” operator returns TRUE if the first value in cell is smaller than the second value in cells. The “ greater than or equal to” (>=) operator will return TRUE if the first value in cells is larger than the second or if the two values are equal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |