HYPERLINK

Definition: HYPERLINK is a function that creates a hyperlink to a specified location.

Syntax: =HYPERLINK(link_location, [friendly_name])

Situation: This formula is suitable when you need to create a hyperlink to a specified location.

Example: If you have a website URL “https://www.google.com”, the hyperlink can be created using the formula =HYPERLINK(““, “Google”), which displays as “Google”.