# ISBLANK function returning unexpected results

I want to show the average of a range if any cell is populated. However, my formula shows the average only if the first cell is populated.

I'm using the below formula:

`=IF(ARRAYFORMULA(ISBLANK(A2:C2)),"",AVERAGE(A2:C2))`

If A2 is populated, the formula's output is not blank, which is expected.

And if A2:C2 is all blank, the formula's output is blank as expected.

However, if A2 is blank while B2 and C2 are populated, the formula's output is blank, which is not what I want:

How do I get the output of the formula to be blank only if the entire range is blank?

Use the following

``=IF(AND(A2="",C2="",B2=""),"",AVERAGE(A2:C2))``

Functions used:

• Is this the only way? I have some ranges that are really long - do I really have to explicitly evaluate each cell? Dec 20, 2020 at 0:21
• No. Certainly not. It is just your formula corrected. See the comment on your question. If still in trouble, please give an example of your ranges. Dec 20, 2020 at 0:24
• Why provide an answer to a duplicate question? Dec 20, 2020 at 0:33
• fair enough, it answered the question as I wrote it. I'll accept this answer Dec 20, 2020 at 4:57
• You can use `IF(CONCATENATE(A2,C2) = "", "", AVERAGE(A2:C2))`. Apr 30, 2021 at 10:09

To check if ALL cells in range `A2:C2` are blank

`=AND(ARRAYFORMULA(ISBLANK(A2:C2)))`

To check if ANY cell in range `A2:C2` is blank

`=OR(ARRAYFORMULA(ISBLANK(A2:C2)))`