in NUMBERS, in a numeric cell, how do i display Blank if the value is ZERO

Hi cajaar,

If the zero is the result of a calculation, then something like this may help:

In other words, if B4-C4 is 0, then the value of cell C8 is set to "" (blank). If it's anything else, then the result of the calculation is displayed.

Alternatively (and this will also work if you simply type in a 0), you could try conditional highlighting:

When the value of the cell is zero, the colour of the text is white so it's invisible against the white fill of the cell. The zero is still there, it just isn't displayed.

Hope this helps,

H

Hi cajaar,

Will the value in this cell be used in further calculations? If so, the value in that cell—0 or ""—could affect results differently down the line, or even cause an error that would block any calculations down the line.

If it is a final value, not used in further calculations, then either of the methods presented by HD will do the job.

If further calculations using the result in that cell include the arithmetic operators ( +, -, *, / ), the text value "" will cause an error (as will the 0 value if it results in a division by 0).

If the cell is to be used as one of the values in an AVERAGE calculation, the 0 will be counted as one of the values to be included in the average (the average of 2, 0, 2 is 0.667), while the "", like all text values, will be ignored (the average of 2,"",2 is 2).

Regards,

Barry

Hi cajaar

Just adding to HD's excellent reply.

Are you using exactly zero or close enough to zero?

1 divided by 9 equals 0.11111111 recurring and extending to infinity.

Cell C1 has Data Format > Automatic > Decimals Auto. Not equal to zero.

Cell C2 has the same formula, but the Data format "hides" the decimal parts. However, the decimal parts are still stored by Numbers. The display shows zero, but the value is not exactly zero.

Just an alert to watch out for "hidden" decimals.

Regards,

Ian.

i agree with HD. I use Conditional Formatting. it leaves a 0 in the cell for further calculations but it is invisible to me.