Example No.1
In the example above we used the NOT formula to match numbers in columns F and G to see if the values match we used “=” between values. If the value in both columns is the same function will return FALSE. If the values in both columns matches function will return TRUE.
Example No.2 with NOT function
In this example, we used the greater than symbol “>” to match if the number in column F is greater than the number in column G. If the number in column F is greater—the function will return FALSE.
This formula might be helpful in some cases but if you need to compare data in columns we suggest doing it without this function. See the example below.
Example No.3 Compare Data Without NOT Function
In this example, you can see that we compared the same data in columns F and G without using the NOT formula. You can see that if the number in column F is greater than the data in column G then the function returns TRUE.
The result in the example would be FALSE.
