Posted to microsoft.public.excel.worksheet.functions

Dave

external usenet poster

Posts: 1,388

Dynamic Range

Hi,
Cell A1=7
Cell B1=IF(A1=7,"","Not 7")
Under these conditions, Cell B1 is blank.
But apparently it's not really blank.
If I make C1= ISBLANK(B1), C1 returns FALSE.
If "" doesn't give a real blank cell, what does?
Regards - Dave.

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic Range	tiptoe	Charts and Charting in Excel	0	February 19th 08 03:28 PM
Dynamic SUM range	Carl	Excel Worksheet Functions	8	October 30th 07 08:03 AM
Dynamic range	prakash	Excel Discussion (Misc queries)	2	September 11th 06 12:24 PM
Dynamic Range with unused formula messing up x axis on dynamic graph	[email protected]	Charts and Charting in Excel	2	February 2nd 06 08:02 PM
dynamic range	GEORGIA	Excel Discussion (Misc queries)	10	June 29th 05 03:02 AM

All times are GMT +1. The time now is 07:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us