Excel formula returning -0 instead of 0

[ibertram]

Hi there,

I am trying to run a function here but it seems that the function will return a negative value only if the values are as follows.

A: 84.90
B: 57.16
C: 27.74

Excel function:
=IF((+A-B-C)=A,0,(+B+A-C))

if I am to play around with values B and C. I will be able to get a positive 0.
i.e. 57.15, 27.75 or 57.17,27.73

Hope someone can help.
Thanks.

 

[BrianB]

It may be due to how you format the cell.

If you are using a non-decimal (integer) format and the number is less than 0 and more than -1 (eg. -0.5) then it would be displayed like that.

 

[Scott Huish]

After modifying your formula with actual cell references, your formula returns 114.32

Book1
	A	B	C	D	E
1	84.9	57.16	27.74		114.32
Sheet1

 

[ibertram]

Let's say you have:
Column A1: 57.16
Column B1: 27.74
Column C1: 84.90

In Column D1, you have this formula: =($A$1+$B$1)-$C$1. Result would be 0
But if you have this formula in column E1: =IF(($A$1+$B$1)-$C$1) = 0, "it
is zero", "it is not zero"). Result would be "it is not zero". Strange
huh?

It seems that it only happens to this set of number.