Explanation
NOT reverses a logical result.
Syntax
=NOT(logical)
Example
=NOT(A2=”Paid”)
If A2 contains Paid → FALSE
If A2 does not contain Paid → TRUE
IF + NOT
=IF(NOT(A2=”Paid”),”Payment Pending”,”Paid”)
Real-World Uses
- Payment status
- Attendance status
- Stock availability
- Task completion
- Verification status
Practice
Create a payment sheet:
|
Student |
Payment Status |
|
Amit |
Paid |
|
Neha |
Pending |
|
Rahul |
Paid |
Use NOT to identify pending students.