HYPERLINK
Returns the friendly name of a hyperlink, or its link location when no name is given.
The returned value is friendly_name when the second argument is present,
otherwise link_location.
The Formualizer engine in this repository at 0.15.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.
Syntax
=HYPERLINK(link_location, [friendly_name])
Arguments
| Argument | Type | Required | Default |
|---|---|---|---|
link_location | any | Required | — |
friendly_name | any | Optional | — |
Differences from Excel
Formualizer returns the friendly name as text. Excel passes numbers and booleans through
with their original type, so =ISNUMBER(HYPERLINK("x",1)) is FALSE in Formualizer and TRUE in Excel.
Examples
Use the destination itself as the displayed text.
Formula =HYPERLINK("https://example.com")
Expected result https://example.com
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Supply independent display text for the same destination.
Formula =HYPERLINK("https://example.com","Open example")
Expected result Open example
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Use an empty display string.
Formula =HYPERLINK("https://example.com","")
Expected result ""
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
An error in the destination expression propagates.
Formula =HYPERLINK(1/0)
Expected result #DIV/0!
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Hyperlink with a friendly name
Formula =HYPERLINK("https://example.com","Example")
Expected result Example
Try this formula
This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.
Related functions
FAQ
What does HYPERLINK return?
The friendly name when provided, otherwise the link location, always as text.