If you’re new to Excel, you may be wondering what the NOT function is and how it can help you. The NOT function in Excel is one of Excel’s logical functions. This function helps check if one value is not equal to another. It supplies the reverse logic value you supply. So I can test if a specific condition is not met.
Example of NOT Function Use.
This week, I needed to flag if a record in Excel did not contain the word ‘Hosting’. This list contained around 1000 records, so I figured it would possibly be a little quicker to use NOT Function than an IF Function. I had not used the NOT function for a while, so it would be time to dust it off. Here is an extract of the type of list I worked on.
So, in this example, I need to test if the cells in Column A do NOT contain the word ‘hosting’. Here a a sample of the data I am working with.
The syntax of NOT is straightforward.
=NOT(logical)
The NOT Function in Excel only has one argument which is logical. See my formula below incorporating the NOT function.
=NOT(A2=”Hosting”)
The non hosting accounts can now be identified and filtered. Just another way to use Logic in Excel.
That’s all for this tutorial on the NOT function in Excel. We hope you found it helpful! If you have any questions, or would like a further explanation of anything we covered, please leave us a comment below and we will get back to you as soon as possible. In the meantime, why not sign up for our newsletter? We send out there free Excel tips monthly like this one, along with exclusive discounts and offers available only to subscribers. Don’t miss out – sign up today!
More Excel Articles.
