dbmathis
Well-known Member
- Joined
- Sep 22, 2002
- Messages
- 1,064
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.
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.