Thread: isBlank()
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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