KRAMER wrote...
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.
....

More expedient to change the approach and not worry about what these
cells evaluate to. Change the formula to

=IF(ABS(H22-[book1]jun!D22)<0.001,"","check book1jun")

Using ABS(x-y)<z rather than x=y means that when x and y are within z
of each other, treat them as effectively equal. For currency amounts,
values differing by less than 0.001 should be considered equal.