.

NOT Function Dictionary

Function Dictionary Function Examples Function Categories

NOT            
 
 
Cells To Test Result
10 20 TRUE  =NOT(C4>D4)
10 20 TRUE  =NOT(C5=D5)
10 20 FALSE  =NOT(C6<D6)
1-Jan-98 1-Feb-98 TRUE  =NOT(C7>D7)
Hello Goodbye TRUE  =NOT(C8=D8)
Hello Hello FALSE  =NOT(C9=D9)
What Does It Do ?              
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.
Syntax                
=NOT(TestToPerform)
The TestToPerform can be reference to cells or another calculation.
Formatting              
No special formatting is needed.
Example                
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.
Taken Loan Returned Status
1-Jan-98 14 5-Jan-98 OK  =IF(NOT(D33<=B33+C33),"Overdue","OK")
1-Jan-98 14 15-Jan-98 OK  =IF(NOT(D34<=B34+C34),"Overdue","OK")
1-Jan-98 14 20-Jan-98 Overdue  =IF(NOT(D35<=B35+C35),"Overdue","OK")

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download