Thanx for reading this post.
I have a table wherein I am working on some values -
( lots of cross references etc) - I have put in checks at some points to verify if the data entered is correct or not.
I end up finding that a-b+c-d will give non-zero answer( some error value)
while a+c-(b+d) will give correct ZERO value.
Please help in deteminig what may be the cause. This may create unneccessary errors - as lots of conditions are invovled which compares these values =0.
( There will be some circular referece also. Hence, I have increased the no, of iterations as well as the accuracy of the answer - FROM tools>Options>calcuations - Could this be the cause of the problem )
I have a table wherein I am working on some values -
( lots of cross references etc) - I have put in checks at some points to verify if the data entered is correct or not.
I end up finding that a-b+c-d will give non-zero answer( some error value)
while a+c-(b+d) will give correct ZERO value.
Please help in deteminig what may be the cause. This may create unneccessary errors - as lots of conditions are invovled which compares these values =0.
( There will be some circular referece also. Hence, I have increased the no, of iterations as well as the accuracy of the answer - FROM tools>Options>calcuations - Could this be the cause of the problem )