If statement with conditional Hyperlink for one output and text for the other

[ShogunStealth]

I need to create and IF statement that when it is true it outputs a hyperlink text and when false it just plain text and so when you hover over the cell [false] it doesn't change to hand?

Sound simple enough but I can't work it out.

Something like =IF(A2=B2,HYPERLINK(B2,"Link"), "No Link")

This treats the "No Link" cells like a hyperlink

 

[PeteWright]

Excel treats hyperlinks with links to cell references differently. You need to include the workbook and sheet name as well as the cell reference like this:

1. = IF(A2=B2, HYPERLINK("[Book1.xlsx]Sheet1!A1", "Link"),"No Link")

   or

2. = IF(A2=B2, HYPERLINK("[Book1.xlsx]Sheet1!A1", "Link"), HYPERLINK("", "No Link"))

When using (1) the once created hyperlink may stay even if the condition is not met.
As a workaround you could use (2).