Hi all.
For the past few months I've been developing, and working on a really large,
and complex worksheet.
Every so often I'll notice that one of my worksheet functions does not
return a simple answer, and when I go tracing it down by modifying the format
of the cell in question I'll notice that instead of returning a zero, or a
true answer-- in the case of my if functions-- it'll return a value that is
so insignificantly small as to be a zero.
E.g.,
If(a4=X,"ok",X-a4)
where X is some numeric value.
If the statement is true, it generally returns the "ok" as my true
statement. However, once in a while I'll get a number and E-16, or E-17,
etc.....
I know that the E to some number is the exponential, raising a number to a
specified power.
It's the issue of it returning that, instead of it giving a zero.
Is there any means by which to over-ride those, and get the "correct"
response?
Thank you.