NOT ()
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.
Best view in desktop mode.
A
|
B
|
C
|
D
|
E
|
F
|
|
1
|
Order No.
|
Cost
|
Payment Type
|
Handling Charge
|
||
2
|
AB001
|
1000
|
Cheque
|
TRUE
|
=NOT(B2>=2000)
|
|
3
|
AB002
|
1000
|
Visa
|
TRUE
|
=NOT(B3>=2000)
|
|
4
|
AB003
|
2000
|
Cheque
|
FALSE
|
=NOT(B4>=2000)
|
|
5
|
AB004
|
5000
|
Delta
|
FALSE
|
=NOT(B5>=2000)
|
|
6
|
||||||
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.
A
|
B
|
C
|
D
|
E
|
F
|
|
1
|
Taken
|
Loan
|
Returned
|
Status
|
||
2
|
1-Jan-20
|
14
|
5-Jan-20
|
OK
|
=IF(NOT(C2<=A2+B2),"Overdue","OK")
|
|
3
|
5-Jan-20
|
14
|
17-Jan-20
|
OK
|
=IF(NOT(C3<=A3+B3),"Overdue","OK")
|
|
4
|
3-Jan-20
|
14
|
20-Jan-20
|
Overdue
|
=IF(NOT(C4<=A4+B4),"Overdue","OK")
|
|
5
|
||||||
No comments:
Post a Comment