Checks whether a value is a valid URL.
Sample usage
ISURL("http://www.google.com")
ISURL("www.google.com")
ISURL("google.com")
ISURL("www.abc.xyz")
Syntax
ISURL(value)
value– The value to be verified as a URL.
Notes
- Google Sheets automatically links text entered into a cell if a valid URL is detected.
ISURLwill returnTRUEin these cases. - A fully qualified URL is not required. In other words, "http" and "www" are not needed in all cases.
- Valid protocols include FTP, HTTP, HTTPS, Gopher, Mailto, News, Telnet and AIM.
- If a URL is flagged as 'False', it may use a top-level domain that isn't on our list.
See also
ISEMAIL: Checks if the value follows a commonly accepted format for email addresses, but doesn't verify its existence.
ISERROR: Checks whether a value is an error.
ISTEXT: Checks whether a value is text.
ISBLANK: Checks whether the referenced cell is empty.
HYPERLINK: Creates a hyperlink inside a cell.