Sum and excel writes -0

[thomexcel]

Well so a lot of good helpers are on this forum So I would hear if someone knows why my excel does this error, that it does. I have an example file, because it's pretty hard to explain, but basically my issue is that when counting points there is value called -0, instead of just 0.

[xlnitwit]

Your calculation results in a very small negative number, since you have no points for wins or draws, then you add goals scored multiplied by 0.0000001 and subtract goal difference multiplied by 0.000001. With no goals scored and -3 goal difference, you get a small negative.

[dominicb]

Good afternoon thomexcel

Cell AA6 is such a cell. The actual value of cell AA6 is -0.00000300, which is why it shows as -0.

To fix this, you can alter the formula to show :

Please Login or Register  to view this content.

HTH

DominicB

[thomexcel]

Good afternoon thomexcel

Cell AA6 is such a cell. The actual value of cell AA6 is -0.00000300, which is why it shows as -0.

To fix this, you can alter the formula to show :

Please Login or Register  to view this content.

HTH

DominicB

Thank you that helped.