format

If you actually want to hide the zeroes, but do not want to remove them, you could use a Conditional highlighting rule to set the Text colour of the cells to match the background colour when the cell contained the number zero.

In the examples above, each of the body cells contains the formula RANDBETWEEN(0,5)

The formula recalculates whenever there is a change in the table. Clicking the checkbox in A1 toggles the value in that cell between true and false.

The second table is simply a copy of the first, and has had the checkbox clicked at least once since it was made.

Regards,

Barry

I just choose my 'Hide 0s' Custom Format from the Data Format dropdown.

Result:

Setting up a Custom Format is easy.

Choose 'Create Custom Format' at the bottom of the Data Format list (see first screenshot).

Click 'Add a Rule', choose 'if equal to' and enter 0.

Then set it up the rest of the custom format. It should look something like this:

An advantage of Custom Format over Conditional Highlighting is that you don't have to worry about matching the background color.

SG

when you say hide zeros. can you be more specific?

assuming you literally mean a cell that has a formula whose result is zero you want to be blank.

if this is the case, then assuming there is an existing formula... assuming that is represented by

<existing formula>

select the cell with the existing formula and select the whole formula

then cut (<command> + x)

then type:

if(<existing formula>=0, "", <existing formula>)

having replaced <existing formula> with the actual formula