HYPERLINK
Creates a shortcut or jump that opens a document stored on a network server, intranet, or the Internet
Syntax
HYPERLINK(link_location, [friendly_name])
Parameters
- link_location: Required. The path and file name to the document to be opened
- friendly_name: Optional. The jump text or numeric value displayed in the cell
Example
=HYPERLINK("https://example.com", "Click here")