=IF(A1="","",AVERAGE(A:A))

will work for blank text strings from formulas

Note that AVERAGE itself ignores the blank text strings and empty cells


--


Regards,


Peo Sjoblom


"JP" wrote in message
s.com...
Hi folks,

Is there a function that will treat a cell as blank, if the cell has a
formula but the result is "" ?

For example, someone is doing data entry in column A

In column B there's a formula =IF(ISBLANK(A1),"",AVERAGE(A:A))

So column C would need to house a formula that checks if the result of
the formula in column B is "". Obviously you can't put
=IF(ISBLANK(B1)) because technically the cell isn't blank.

I feel like there is a way to do this. What am I missing here?


Thx,
JP