Display if hyperlink path incorrect

[bajdr47]

Afternoon All,

I have a query around a hyperlink please

Is there a function that i can add to a cell to display if the hyperlink path is valid

ie to show that the hyperlink path does not exist, I am feeding the hyperlink from 2 cells

Regards

Baj

[FDibbins]

Maybe wrap the hyperlink in IFERROR - for 2007 and later or =IF(ISERROR(your-hyperlink),"No Path",your hyperlink)