| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
An empty cell = An empty cell ???
Use the IsBlank() worksheet function somewhere in your formula to check
both cells first. -- Regards, Bill Renaud |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
An empty cell = An empty cell ???
Maybe...
=if(and(a1=a2,a1<""),1,0) amirstal wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When is a cell empty and how do I empty it. | Excel Discussion (Misc queries) | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Finding next empty empty cell in a range of columns | Excel Programming | |||
| Empty cell and a the empty String | Excel Programming | |||
![amirstal[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
