Hey folks,
If I enter in cell A1, If(criteria,"",""), as I understand it, should return a blank value. If I then test that cell for a blank value using Isblank(A1), I am for some reason receiving a "false" output.
It is as if Isblank() cannot detect that cells which If() has left blank are blank. Isblank() appears to be confused by the presence of a formula in the cell, leading it to return a conclusion that the cell is not blank.
Anyone know a way to work around this?
Thanks in advance
Hi and welcome to the forum
A cell that has "" in it (say, from another formula) is not blank, so ISBLANK() is not confused, it is returning what it should. A blank cell is 1 that has nothing in it. to test for "", you need to use =if(cell="",............
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you. Do you also have something to test for the presence of anything in a cell, other than Isblank?
For example, I was under the impression that If(a1="*"... would test for the presence of anything, but apparently it simply tests for the presence of an asterisk, hah.
maybe =if(A1<>""................?
* is normally used in a wildcard search......th* would find this, that, them but not Tim
The IF function doesn't support the use of wildcards.
Also, the wildcard * doesn't work on numbers. It works on TEXT only. So, technically, * doesn't mean "anything".
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks