Sean - you get the prize. I modified your response to round to two places
instead of zero, but this worked. I can't say I understand, since
everything is formatted the same, but it does work, so now I can get on with
more productive things. This forum is wonderful!

Steve



"Sean Timmons" wrote:

I have to ask first, have you typed into the cell =K5+K18-K37, then in
another cell, =I5+I18-I37?

If they show as matching, you may want to round in case that's the issue...

=IF(ROUND((K5+K18-K37,0)=ROUND(I5+I18-I37,0),"Balances","Out of Balance")

"stebro" wrote:

I need help troubleshooting an IF stamtent that is determining that the
values in two cells are different. The statement is literally

=IF((K5+K18-K37)=(I5+I18-I37),"Balances","Out of Balance")

The "K" series and the "I" series all evaluate to exactly the same thing so
the statement should be evaluating as TRUE but evaluates as FALSE.

I have removed as many variables as possible - for instance the series are
the results of other calculations, but I've dummied it down to just looking
at the values and it still tays they aren't equal.

I've seen this type of thing before related to the cell formats, but in this
case the formats are identical. I'm at the end of my rope - anybody out
there have anything left???

Most appreciated -
Steve