CODEWITHSUNDEEP
excelhyperlinkexcel-formula
iOSecure
iOSecure

Reputation: 232

Add hyperlink and formula within the same cell

Is it possible to add a hyperlink and a formula in the same cell from the formula bar*? I'm trying to have a file link to the percentage but I need it to calculate the percent too.

This is the formula already in it:

=IFERROR(P2/P4,"NA")

But I'd also like to add:

=HYPERLINK("..\..\MyFileA.xlsx","FileA")

Upvotes: 2

Views: 448

Answers (2)

Robin Mackenzie
Robin Mackenzie

Reputation: 19319

The syntax for HYPERLINK is:

HYPERLINK(link_location, [friendly_name])

So you want to put your descriptive stuff in the friendly_name parameter and just the link itself in the link_location. Per you example in the question the formula would read:

=HYPERLINK("..\..\MyFileA.xlsx",IFERROR(TEXT(P2/P4,"##.00%"),"NA")&" % - FileA")

Upvotes: 2

Forward Ed
Forward Ed

Reputation: 9874

=HYPERLINK("http://www.google.ca",IFERROR(P2/P4,"NA"))

replace the web link with your file path

Upvotes: 2

Related Questions