# Re: On writing negative zero - with or without sign

From a mathematical viwpoint:-

A zero value is a concept that is neither positive nor negative.
It is outside these two states, being the only member of a third
state.
(1-1/x) for all positive values of x yields a negative real value.
(1+1/x) for all positive values of x yields a postive real value.

If a real value very close to zero has to be expressed in a limited
number of fractional digits, but these digits are all zeroes after the
decimal point, then the appropriate sign should be prefixed to the
values to indicate which side of absolute zero the values lies.

.

## Relevant Pages

• Re: Division by zero
... infinity, unless the numerator is also zero, in which case it yields NaN. ...
(comp.lang.c)
• Re: Small numbers are labeled as Zeros
... Excel only supports 15 significant digit. ... Frank Kabel ... > This value is labeled as Zero in the cell and when I multiply it by ... > other number it yields to Zero instead of some value multiply by ...
(microsoft.public.excel.misc)
• Re: Help with a COUNTIF (I think)
... Still yields a zero. ... > to do is count the cells. ... >>> eliminating the double quotes but I can't get it to work. ...
(microsoft.public.excel.worksheet.functions)
• Re: C Questions
... pete said: ... yields 0 if its scalar operand does not compare equal to zero, ...
(comp.lang.c)
• Small numbers are labeled as Zeros
... I have a really small result of a rpobability that yields up to ... This value is labeled as Zero in the cell and when I multiply it by any ...
(microsoft.public.excel.misc)