How to handle linked cells?

Closed
Philcokin
Posts
1
Registration date
Friday August 31, 2012
Status
Member
Last seen
August 31, 2012
- Aug 31, 2012 at 06:29 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Sep 11, 2012 at 06:03 AM
Hello,

I am trying to get this formula to work: =IF(T8=0,"100% with PO",T8&" days, NET")

T8 is linked to another table and contains the following: ='C:\XSalesTrack\[address merge.xls]Address Merge'!$V$2

So, my "IF" formula does not work because it does not reads zero because of the link. If i enter "0" in the linked cell, it will return " 0 dys NET" instead of "100% with the order"

If anyone can help me, it will be appreciated. Thank you.

Phil

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Sep 11, 2012 at 06:03 AM
0