Excel Study · Module 3: Decisions with IF
Class 27Is it blank? ISBLANK vs ""
Intermediate1:49 videoFree
ISBLANK is TRUE only when a cell is truly empty. Inside IF it turns a task list into a live tracker: Pending while the "done on" date is empty, Done the moment someone types a date.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, B2 has the date a task was done, or is empty if it is not done yet. Write a formula for D2 that shows Pending if B2 is empty, otherwise Done.
The answer that works
✓ checked in Excel=IF(B2="", "Pending", "Done")
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.