Multiply a text value by FALSE

Hi

I have a cell (A1) which evaluates to TRUE or FALSE. In A2 I have a complex formula which gives a text string. I want to make the text disappear if A1 is FALSE.

If A2 were a number it would be easy, I just multiply A1*A2 (my workbook does not display zeros). But I can't do that with a text.

I could do it OK with an IF function, set A2 to 0, or null, but the formula in A2 is already messy.

I doubt there is an easier way to do this, but if anyone has a trick please let me know.

Thx as always, Trebor

I agree, and suspect I will have to use this route. I want to avoid conditional formatting because I use it so extensively already, and it can get messy. Thanks for the input.