Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isBlank()
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isBlank()
Try this:
=IF(A1="","blank but not empty","contains something else") Hope this helps. Pete On Feb 8, 4:33 pm, "alex" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isBlank()
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 In article om, "alex" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isBlank()
On Feb 8, 11:37 am, "Pete_UK" wrote:
Try this: =IF(A1="","blank but not empty","contains something else") Hope this helps. Pete On Feb 8, 4:33 pm, "alex" wrote: 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- Hide quoted text - - Show quoted text - Pete, You helped answer my question: instead of using isBlank, I used "". Thanks. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isBlank()
Thanks for the feedback - glad to help.
Pete On Feb 8, 4:49 pm, "alex" wrote: On Feb 8, 11:37 am, "Pete_UK" wrote: Try this: =IF(A1="","blank but not empty","contains something else") Hope this helps. Pete On Feb 8, 4:33 pm, "alex" wrote: 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- Hide quoted text - - Show quoted text - Pete, You helped answer my question: instead of using isBlank, I used "". Thanks.- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isBlank()
JE McGimpsey 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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
isBlank()
In article . com,
"Harlan Grove" wrote: To be fair, this is one of Microsoft's more boneheaded mistakes. And that's saying a lot... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif & Isblank | Excel Worksheet Functions | |||
ISBLANK returns flase when there is nothing in the cell referenced | Excel Discussion (Misc queries) | |||
ISBLANK Formula Help Request | Excel Worksheet Functions | |||
VLOOKUP & ISBLANK | About this forum | |||
Is there a function for "not isblank" (find a cell that has a val. | Excel Worksheet Functions |