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

=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

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

OR

TYPE(B1)



"JP" skrev:

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

Thanks guys!

On Oct 25, 1:12 pm, excelent
wrote:
=IF(B1="","EMPTY","NOT EMPTY")

OR

TYPE(B1)

"JP" skrev:



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- Hide quoted text -

- Show quoted text -