Posted to microsoft.public.excel.programming

amirstal[_2_] amirstal[_2_] is offline

external usenet poster

Posts: 18

An empty cell = An empty cell ???

When I use two empty cells, excel treats them as if they contain the
same, equal data. So, for example, if both A1 and A2 are empty, the
following formula will return "1": IF(A1=A2,"1").

But I don't want excel to treat those two cells as being equal as long
as they don't really contain any data. So in this case, the above
formula will not return the number "1".
How can I do it?

Thanks,

Amir

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
When is a cell empty and how do I empty it.	C Brandt	Excel Discussion (Misc queries)	5	August 13th 07 05:37 PM
Leaving an empty cell empty	GRL	Excel Discussion (Misc queries)	4	April 22nd 06 05:47 PM
why a reference to an empty cell is not considered empty	Nicoscot	Excel Discussion (Misc queries)	10	March 10th 06 05:36 AM
Finding next empty empty cell in a range of columns	UncleBun	Excel Programming	1	January 13th 06 11:22 PM
Empty cell and a the empty String	JE McGimpsey	Excel Programming	0	September 13th 04 04:12 PM

All times are GMT +1. The time now is 02:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us