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 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 11, 2012 at 06:03 AM
rizvisa1 Posts 4478 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
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
Related:
- How to handle linked cells?
- How to recover instagram account linked with facebook - Guide
- How to open a local file link on iphone - Guide
- How to delete whatsapp chat from all linked devices - WhatsApp Forum
- How to undo remove link on instagram bio ✓ - BIOS Forum
- Pinterest handle - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Sep 11, 2012 at 06:03 AM
Sep 11, 2012 at 06:03 AM
Try to use an addon called MOREFUNC.
https://download.cnet.com/Morefunc/3000-2077_4-10423159.html
https://download.cnet.com/Morefunc/3000-2077_4-10423159.html
