top of page
  • Writer's pictureDp

"NOT" Function In Excel

Updated: May 2, 2019

This function performs a test to see if the test fails. (A type of reverse logic).

If the test fails, the result is TRUE.

If the test is met, then the result is FALSE.




The following table was used by a library to track books borrowed.

The date the book was Taken out is entered.

The period of the Loan is entered.

The date the book was returned is entered.

The =NOT() function has been used to calculate whether the book was returned within the correct time, by adding the Loan value to the Taken date.

If the book was not returned on time the result Overdue is shown, otherwise OK is shown.

Here is the video tutorial of the same for clear understanding.

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at


Recent Posts

See All


bottom of page