Expand my Community achievements bar.

Nomination window for the Adobe Community Advisor Program, Class of 2025, is now open!
SOLVED

Hiding the Zero in the Sum Cell

Avatar

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.

1 Accepted Solution

Avatar

Correct answer by
Level 1

I am using FormCalc, of course.

View solution in original post

3 Replies

Avatar

Correct answer by
Level 1

I am using FormCalc, of course.

Avatar

Level 6

Put this in the display pattern:

null{}

Avatar

Level 1

Thank you!