Function to treat formula result as blank cell

[JP]

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

 

[Peo Sjoblom]

=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

 

[excelent]

=IF(B1="","EMPTY","NOT EMPTY")

OR

TYPE(B1)



"JP" skrev:

 

[JP]

Thanks guys!

=IF(B1="","EMPTY","NOT EMPTY")

OR

TYPE(B1)

"JP" skrev:










- Show quoted text -