I have a summary page and in one column there are hyperlinks to a cell on
another worksheet. In the next column, I would like to use the value of that
hyperlinked cell if a hyperlink exists there. So I need something like
(assuming it's in cell B1)

=SomeFormula + If(IfExistHyperlinkIn(A1), Indirect(a1), 0)

I have tried but can't figure it out. Could someone help?

Also, I see that a hyperlink can be added by right clicking and selecting
from the popup menu or by using the HYPERLINK worksheet function. Any
difference between these methods and any pros or cons?