Definition. This function checks a logical condition and performs the first action specified after the test argument if the condition is true and the second action if it is false.
logical_test (required). Any value or expression that can be evaluated to TRUE or FALSE
This argument can use any comparison operator:
Equal sign (=). You can directly compare the content of a cell with a number (A1=7), or you can compare two cells (A1=B1).
Greater than (>) or less than (<). You can directly compare the content of a cell with a number (A1>7 or B1<8), or you can compare two cells (A1>B1 or C1<D1).
Greater than or equal to (>=), less than or equal to, (<=), or not equal (<>). The not equal sign ...