Showing the Result as Text
Key points
- Enter the text for true
- Enter the text for false
- Copy the second formula
ISBLANK Builder also builds a formula that shows the result as text such as OK or NG.
Steps
- Enter the text for true
- Enter the text for false
- Copy the second formula
You can change the text to anything you like.
Use "Build an ISBLANK Formula" (free)
Tools that go well with this
- Build an IF Formula: Build an IF formula.
- Build a Conditional Formatting Formula: Build conditional formatting formulas.
- Build a COUNTIF Formula: Build formulas that count cells meeting a condition.