How can I do a function around a workbook link?

[cheeseontoast101]

Hi

I'd like to incorporate an if error into

='{testworkbook.xlsx]sheet1'!D7

how can I do this?

[#2]

You should be able to use the IFERROR function as normal as follows (where if true it simply returns the text 'Error'):

=IFERROR('{testworkbook.xlsx]sheet1'!D7,"Error")