Forum Discussion
Solved
If statements with linked data in a cell.
Good Morning, Basic Excel user, I have linked data (dates) from another spread sheet. The linked data shows "0" on the new sheet. I converted the cells to Date and now the linked cells show a dat...
=IF('C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2="","",'C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2)
=IF('C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2="","",'C:\Users\dkb\Downloads\[HDE2900B1.1.xlsx]HCM - Learning Transcripts'!Z2)
