cell formatting problem

Copper Contributor

Why does the cell show a zero when adjacent cells show a dash? The cell formatting across the row is set the same:

_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_) Custom fomatting

The formula is =D14+D18+D23 in one cell and results in a zero

The formula is copied across and the adjacent cells are dashes.

When I changed the row to all general number formatting, the cells with a zero show:

2.91038E-10  What is that??? Help!

2 Replies

@KayPin 

This means that the formula returned a value that is slightly different from zero because of rounding errors.

If all your numbers have up to (for example) 2 decimal places, change the formula to

 

=ROUND(D14+D18+D23,2)

 

The result will then be exactly 0, and be displayed as a dash.

Thank you! That worked great.