 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007isBlank()
Hello experts, I'm trying to use the isBlank() function to in one cell to reference another directly to the right. Problem is, however, that said cell to the right, while holding a null value, also has a formula causing the isBlank function to return false. Is there a function that will return true if the cell is empty and has an associated formula? Thanks for the time, alex Try this: =IF(A1="","blank but not empty","contains something else") Hope this helps. Pete > Hello experts, > [quoted text clipped - 10 lines] > Thanks for the time, > alex > Try this: > [quoted text clipped - 20 lines] > > - Show quoted text - Pete, You helped answer my question: instead of using isBlank, I used "". Thanks. Thanks for the feedback - glad to help. Pete > > Try this: > [quoted text clipped - 28 lines] > > - Show quoted text - Blank means blank, not containing a formula. If the formula returns the null string, then compare the value with the null string: B5: =C5="" or B5: =LEN(C5)=0 > Hello experts, > [quoted text clipped - 10 lines] > Thanks for the time, > alex JE McGimpsey <jemcgimp...@mvps.org> wrote... >Blank means blank, not containing a formula. ... To be fair, this is one of Microsoft's more boneheaded mistakes. ISBLANK likely got its name from the mnemonic returned by CELL("Type",SomeRange), which returns "b" when the top-left cell in SomeRange has nothing in it. Microsoft was able to figure out ISTEXT rather than ISLABEL despite the fact that CELL("Type",...) returns "l" (lower case L) when the top-left cell evaluates as a text string. Further, most non-English variants of the ISBLANK function have names that translate back into English as ISEMPTY. And, FWLIW, the equivalent Lotus 123 function is named @ISEMPTY. > To be fair, this is one of Microsoft's more boneheaded mistakes. And that's saying a lot... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.