Mar 27 2021 08:33 AM
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!
Mar 27 2021 08:52 AM
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.