Logically comparing cells that are in two separate .xls file

[dbmathis]

I have one cell:

C:\Documents and Settings\David B. Mathis\My Documents\Cash Flow Statements\Cash Flow.xls

Cell J63

=IF(COUNT(H41:H45)=0,(H74+H77)-(cleared+SUM(H50:H60)),IF(COUNT(H41:H45)=1,(H74+H41+H77)-(cleared+SUM(H50:H60)),IF(COUNT(H41:H45)=2,(H74+H41+H42+H77)-(cleared+SUM(H50:H60)),IF(COUNT(H41:H45)=3,(H74+H41+H42+H43+H77)-(cleared+SUM(H50:H60)),IF(COUNT(H41:H45)=4,(H74+H41+H42+H43+H44+H77)-(cleared+SUM(H50:H60)),IF(COUNT(H41:H45)=5,(H74+H41+H42+H43+H44+H45+H77)-(cleared+SUM(H50:H60)),0))))))

It's value is 297.14

and....

The other cell:

='C:\Documents and Settings\David B. Mathis\My Documents\Transaction Registers\[Transaction Register Starting Aug-15-2002 Draft.xls]Transaction Register'!M24

This cells value is 297.14

My problem is when I use the following formula in the Cash Flow.xls I keep getting FALSE.

=IF(J63='C:\Documents and Settings\David B. Mathis\My Documents\Transaction Registers\[Transaction Register Starting Aug-15-2002 Draft.xls]Transaction Register'!M24,"Balanced","Not Balanced")

The result is Not Balanced?

The value of J63 and M24 are both 297.14?

Should not the above formula evaluate to TRUE?

Does the fact that I am performing a logical evaulation across two files effect the outcome?

I need help please.

 

[Jim North]

Is your Draft.xls open?

 

[dbmathis]

Yes, It is open.

Although it updated the value regardess of being open or closed.

 

[Don C]

If either value is calculated, it is probable that the underlying values are not equal. You are displaying to two decimals, but the cell values go well beyound two decimals, so they only LOOK like they are equal.

You might need to ROUND both values to two decimals to make them equal.

 

[dbmathis]

Thankz Don... That fixed it.

I had thought about that but I was dealing with even money values and couldn't see a reason for the value to go beyond two decimals..

Apparently I was wrong