How to set BLANK in IF statement in excel [duplicate]

Question

I just want a simple IF(condition,BLANK) that can be picked up by ISBLANK().

I tried the "", it does set it seemingly blank, but when I chain it with a ISBLANK() on that "" cell, it returns FALSE. Is there a way where I can set it so that ISBLANK will detect the output being BLANK?

Ike · Accepted Answer · 2024-04-23 11:58:59Z

2

The cell is not blank due to the formula.

But you can check the length of the cell value:

=LEN(B1)=0

where B1 contains the IF-formula

answered Apr 23, 2024 at 11:58

Ike

13.4k6 gold badges20 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to set BLANK in IF statement in excel [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related