Excel Study · Module 3: Decisions with IF
Class 25Not equal (<>) and NOT
Intermediate1:44 videoFree
"Not equal to" is written as a less-than sign followed by a greater-than sign. Use it inside IF to flag every invoice that is NOT Paid — Pending, Overdue, anything else.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B5 has an invoice status. Write a formula for C8 that shows Follow up if the status is anything other than Paid, and shows nothing if it is Paid.
The answer that works
✓ checked in Excel=IF(B5="Paid","","Follow up")
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.