deepcalc
DocsHYPERLINK

HYPERLINK

View as markdown/docs/functions/hyperlink.md Ask Claude about this pageOpens Claude with this page's address

The text a link displays: clickability is the renderer's.

  • Excel: Differs in detail
  • Google Sheets: Differs in detail
  • Returns: Text

Examples

=HYPERLINK("https://deepcalc.com", "deepcalc")
Result deepcalc

Syntax

HYPERLINK(link_location, [friendly_name])
link_location
text required
friendly_name
text optional
ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string. LOOKUPLooks up value in one-row or one-column range.