Blank cells that have formulas in them

[rdepuydt]

Cell B1 has a formula in it that displays a blank cell. If I write =If(B1=" ",True,False) it returns False. How do you evaluate a cell that has a formula in it but displays a blank?

 

[AlanSidman]

=isformula(B1)

 

[rdepuydt]

I need column L to put TRUE in it if cells in H, I, or J have a value displayed. If all three of them show blank, FALSE.

 

[Fluff13]

How about
=NOT(AND(H11="",I11="",K11=""))

But you need to make sure that all the formulae in those columns return "" rather then " "

 

[Peter Bartholomew]

The most direct interpretation of your condition might be
= OR(ISNUMBER($H11:$K11))