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 Version 8.2.

[jimpaparella · Accepted solution]

I am using FormCalc, of course.

[paulk07]

Put this in the display pattern:

null{}

[jimpaparella]

Thank you!