View Single Post
  #1   Report Post  
ibertram
 
Posts: n/a
Default Excel Function returning negative 0


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.


--
ibertram
------------------------------------------------------------------------
ibertram's Profile: http://www.excelforum.com/member.php...o&userid=28730
View this thread: http://www.excelforum.com/showthread...hreadid=484212