EMAILVALID

EMAILVALID(value)
Returns whether a string is a valid email address.

REMARKS
* Must contain an ampersand, ampersand cannot be the first character, must contain a period, must be at least 2 characters after the period
* This page has the equivalent VBA function.