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.
Bookmarks