Detecting Formula Result

[Alec Kolundzic]

I have the following formula in a cell,(B12), and in
another cell I want to detect whether the B12 contains
text (True) or is blank (False)

=IF(M981<>0,CONCATENATE("Control Cable
to ",Q981," ",G981),"")

Thanks
Alec

 

[JulieD]

Hi Alec

one way:
=IF(B12="","is false","is true")

Cheers
JulieD

 

[Alec Kolundzic]

Thanks Julie

It works a treat.

-----Original Message-----
Hi Alec

one way:
=IF(B12="","is false","is true")

Cheers
JulieD




.