About Us

JP[_3_]

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 -

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to get Blank into a cell as a result of a formula	jkb_junk	Excel Worksheet Functions	2	January 10th 07 03:37 AM
Force Excel To Treat A Cell As Blank	MDW	Excel Worksheet Functions	3	October 16th 06 09:52 PM
Formula result as real empty/blank cell	Excelerate-nl	Excel Worksheet Functions	4	August 20th 06 06:52 AM
How to get a formula result zero as blank cell	Excelerate-nl	Excel Discussion (Misc queries)	4	November 22nd 05 04:32 PM
Lookup formula - treat no-registered cells as blank	gublues	Excel Worksheet Functions	4	June 13th 05 10:32 PM

Menu

About Us