Jerry & Ron,
Thank you, I do feel stupid, I should have thought of rounding but never
expected that summing of cells formatted as currency with only 2 decimal
places could possibly get out of sink. Still learning I guess. No matter it
works now so thank you again.
--
KRAMER


"Jerry W. Lewis" wrote:

It may be simpler than decimal/binary issues. Since H22 is a sum, the
question is what is it summing? If the cells being summed are
themselves formulas, then there may be more decimal places in the result
than the OP is displaying (formatting does not impact the underlying
value). Regardless, the solution is to round, as you suggested.

Jerry

Ron Rosenfeld wrote:

On Mon, 20 Jun 2005 19:11:02 -0700, KRAMER
wrote:


Hi Guy's,

I don't know if I've done something wrong or what, but, I have a sum in one
book and a different sum in another. I am using the IF function to basically
tell me when the two results differ. Now the results are the same e.g.
"$70.65" but the function =IF(H22=[book1]jun!D22," ","check book1jun") is
showing false when I know that both cells equal "$70.65". I double checked by
removing the sum from cell H22 and typing 70.65 (formatted as currency of
course) and the function then says true. I am using IF function to match
other sum results and no problem.
Pease help I am really freaked about this!!


Well, both cells really do NOT equal $70.65

Excel (as well as other spreadsheet programs) does NOT have infinite precision.
Also, many numbers cannot be expressed exactly in binary (much like the
fraction 1/3 cannot be expressed exactly in decimal, but rather is equal to
0.3333333...)

The fix for this normal Excel behavior is to round your results at some point
prior to your testing.

For a more in depth discussion, see http://www.cpearson.com/excel/rounding.htm
or search the archives. The issue appears in this NG at least once or twice a
week.


--ron