I was never good at maths, but am I correct in thinking that

IF((+A-B-C)=A
is the same as
IF((-B-C)=0
and the same as
IF(B+C=0
and the opposite of
IF(B+C

which would then reduce to

=IF(B+C,A+B-C,0)

which should give zero only when B and C are equal and opposite, or
when A+B-C totals zero.

Does this help your thoughts?


ibertram Wrote:
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.


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