Hiding the Zero in the Sum Cell

[Former Community Member]

I created a simple multiplication formula in a row of my table: (Cell2*Cell3)

...now I want the zero in the sum cell to be invisible if no number is entered in Cell2. How do I do that?

I am using FormCalc in Version 8.2.

[radzmar]

Hi,

you can add a display pattern, to show only a space character if the value is null.

zero{ }|num{zzzzzzzzzzzz9}

[Former Community Member]

That works! One more question: How can I show a dollar sign ($) in the sum cell and also have that hidden if no number is entered in Cell2?

[Former Community Member]

Never mind, I figured it out in the Edit/Patterns/Display section. Thanks again!