Why =if(A2:A4="",1,0) will output #VALUE ?

[Guest]

How to check if there is empty cell in a range by using IF Statement ?

I used to use IF Statement to detect empty cell within a range as EXAMPLE
listed below. It works in the past but suddenly fails and output "#VALUE".
Why ?

BEFORE :
Statement : =IF(A2:A4="",1,0)
When A3 = "Null"
Output : "1"

PRESENT :
Output : "#VALUE"

 

[Guest]

It is an array entry. You need to press shift-ctrl-enter in order to get it
works.

 

[JE McGimpsey]

One way:

=--(COUNTIF(A2:A4,"")>0)

alternatively (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=OR(A2:A4="")


Don't know why your formula worked in the past...