| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ISBLANK returns flase when there is nothing in the cell referenced
I am using the ISBLANK function before comparing values in cells, so that I
don't get a match when there is no data to compare. Excel is returning a false (implying that the cell contains data), but nothing appears in the cell being tested. The data being tested by ISBLANK has come from an extract of an ACCESS database, if that has any bearing on the outcome. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISBLANK returns flase when there is nothing in the cell referenced
is there a blank space in the cell, try =code(a1) or whatever the cell is
and see if a number comes up, 32=space. "cugrngneer" wrote: I am using the ISBLANK function before comparing values in cells, so that I don't get a match when there is no data to compare. Excel is returning a false (implying that the cell contains data), but nothing appears in the cell being tested. The data being tested by ISBLANK has come from an extract of an ACCESS database, if that has any bearing on the outcome. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISBLANK returns flase when there is nothing in the cell refere
thanks for the suggestion. It returns #value. Does that mean that there is
nothing there? "dlw" wrote: is there a blank space in the cell, try =code(a1) or whatever the cell is and see if a number comes up, 32=space. "cugrngneer" wrote: I am using the ISBLANK function before comparing values in cells, so that I don't get a match when there is no data to compare. Excel is returning a false (implying that the cell contains data), but nothing appears in the cell being tested. The data being tested by ISBLANK has come from an extract of an ACCESS database, if that has any bearing on the outcome. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISBLANK returns flase when there is nothing in the cell refere
Maybe this will help
http://makeashorterlink.com/?I1346540D -- Regards, Peo Sjoblom http://nwexcelsolutions.com "cugrngneer" wrote in message ... thanks for the suggestion. It returns #value. Does that mean that there is nothing there? "dlw" wrote: is there a blank space in the cell, try =code(a1) or whatever the cell is and see if a number comes up, 32=space. "cugrngneer" wrote: I am using the ISBLANK function before comparing values in cells, so that I don't get a match when there is no data to compare. Excel is returning a false (implying that the cell contains data), but nothing appears in the cell being tested. The data being tested by ISBLANK has come from an extract of an ACCESS database, if that has any bearing on the outcome. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISBLANK returns flase when there is nothing in the cell refere
I think this is what I needed. Thanks. BTW, where did this stuff come from?
"Peo Sjoblom" wrote: Maybe this will help http://makeashorterlink.com/?I1346540D -- Regards, Peo Sjoblom http://nwexcelsolutions.com "cugrngneer" wrote in message ... thanks for the suggestion. It returns #value. Does that mean that there is nothing there? "dlw" wrote: is there a blank space in the cell, try =code(a1) or whatever the cell is and see if a number comes up, 32=space. "cugrngneer" wrote: I am using the ISBLANK function before comparing values in cells, so that I don't get a match when there is no data to compare. Excel is returning a false (implying that the cell contains data), but nothing appears in the cell being tested. The data being tested by ISBLANK has come from an extract of an ACCESS database, if that has any bearing on the outcome. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISBLANK returns flase when there is nothing in the cell refere
If you have formulas that evaluate to "" (=if(a15,"","ok") and convert it to
values (copy|paste special|values), you'll be left with this junk. cugrngneer wrote: I think this is what I needed. Thanks. BTW, where did this stuff come from? "Peo Sjoblom" wrote: Maybe this will help http://makeashorterlink.com/?I1346540D -- Regards, Peo Sjoblom http://nwexcelsolutions.com "cugrngneer" wrote in message ... thanks for the suggestion. It returns #value. Does that mean that there is nothing there? "dlw" wrote: is there a blank space in the cell, try =code(a1) or whatever the cell is and see if a number comes up, 32=space. "cugrngneer" wrote: I am using the ISBLANK function before comparing values in cells, so that I don't get a match when there is no data to compare. Excel is returning a false (implying that the cell contains data), but nothing appears in the cell being tested. The data being tested by ISBLANK has come from an extract of an ACCESS database, if that has any bearing on the outcome. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| =CELL("filename") VOLATILE? | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Linear Mode
