Course
ISBLANK, ISNUMBER and ISTEXT practice exercises
Five exercises, from a single ISBLANK to a status built from two nested tests. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Read the ISBLANK, ISNUMBER and ISTEXT tutorial
Exercise 1 of 5
Flag missing emails
Some contacts have no email yet. In C2, write an ISBLANK that returns TRUE when the email in B2 is empty, then copy it down to C6.
| Name | Email missing | |
| Olivia Reed | olivia.reed@northwind.com | |
| James Carter | ||
| Sofia Patel | sofia.patel@mapleproduce.com | |
| Liam Brooks | liam@brooksdesign.co | |
| Emma Hughes |