Help in linked spreadsheets

[tbones]

I have a spreadsheet that is linked to another workbooks spreadsheet. On the spreadsheet where it copies the data from the linked workbooks spread sheet I have a formula that creates a value from another cell on the data sheet that copies from the linked spread sheet .
Without the linked workbooks spread sheet the formula works fine but as soon as the spreadsheet is linked then the formula does not work.

Here is the formula

=IF(OR(C3="",D3=""),"",IF(AND(C3=I3,D3=J3),1,"0"))

So in essence without the linked workbooks spread sheet what this does is basically match the data in C3 and D3 with date in I3 and J3 and which gives a value of 1 or if it does not match gives a value of 0 and also if cells C3 and/or D3 are blank then I3 and J3 will be blank.

The values 1 or 0 or blank once populated goes into cell M3.

However when I link C3 and D3 to a separate workbooks spread sheet (basically it copies what is on the other spreadsheet) if the other spreadsheet is blank it then makes the cell M3 =1 which is not what I want to do.
It looks like when linking the data from another workbooks spreadsheet it seems to corrupt the value of cell M3

To link the cells C3 i use the formula ='Sign in to your Microsoft account 0 0 Football Prediction League 2021 to 2022/Football project link/[Player 1 1.xlsm]Sheet1'!C3

Any help would be appreciated or if you need more info then I can give it.

Here is a picture of the worksheet I am linking to

Here is a picture of the linked workbooks spread sheet

 

[tbones]

I think I have managed to resolve it by using this formula =IF(OR('[Player 1.xlsm]Sheet1'!$C$5=""),"",'[Player 1.xlsm]Sheet1'!$C$5) and that seemed to work.

 

[FormR]

Hi, with XL365 you can also try like this:

=LET(LINK,'[Player 1.xlsm]Sheet1'!$C$5,IF(LINK="","",LINK))