Formulas and Functions

Chapter 9 Reference Functions 213
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
HYPERLINK
The HYPERLINK function creates a clickable link that opens a webpage or new email
message.
HYPERLINK(url, link-text)
 url: A standard universal resource locator. url is a string value that should contain a
properly formatted universal resource locator string.
 link-text: An optional value that species the text that appears as a clickable link in
the cell. link-text is a string value. If omitted, url is used as the link-text.
Examples
=HYPERLINK(”http://www.apple.com”, “Apple”) creates a link with the text Apple that opens the
default web browser to the Apple homepage.
=HYPERLINK(”mailto:[e-mail]?subject=Quote Request”, “Get Quote”) creates a link
with the text Get Quote that opens the default email application and addresses a new message to
[e-mail] with the subject line Quote Request.
Related Topics
For related functions and additional information, see:
“Listing of Reference Functions” on page 206
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41