I tried to use =hyperlink formula within a nested if formula, I can see the
link underline btu when I click on the link, it show "cannot open specific
file".

The link is to same file, different worksheet.

Please help