How can I do a function around a workbook link?

Contributor

Hi

 

I'd like to incorporate an if error into

 

='{testworkbook.xlsx]sheet1'!D7

 

how can I do this?

1 Reply
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")