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.
This exercise is part of the course
Intermediate Google Sheets
Exercise instructions
The column "Olympic team site" contains a URL to the Olympic team for the athlete's nation. In cell I2, there is a formula to create a hyperlink to the USA site.
- Copy the formula in
I2down as far asI20. - In cell
A21, use=ISURL(A2)to check if this is a URL. - Copy this formula right as far as
I21. - On row
22, use=ISFORMULA()to check if the cells fromA2toI2contain formulas.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise