Checking rarer data types

Google Sheets also allows checks for rarer data types beyond number, text, date, and logical. In this exercise you'll use ISURL() to check for website URLs, and ISFORMULA() to check for cells that contain formulas.

ISURL() checks that the text in a cell takes the form of a URL. This includes text that starts with a protocol, like http://, ftp:// and mailto:, and guesses at other text like somewebsite.com.

To make the text into a clickable hyperlink, use HYPERLINK(). This takes the address of a cell containing a URL and optionally the address of a cell containing the text to display, for example HYPERLINK(A1, B1).

ISFORMULA() takes the address of a cell and returns TRUE when that cell contains a formula. For blank cells and cells with fixed values, it returns FALSE.