Formualizer Docs

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

ArgumentTypeRequiredDefault
link_locationanyRequired—
friendly_nameanyOptional—

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?.

FAQ

The friendly name when provided, otherwise the link location, always as text.

Implementation

Engine source

On this page