ISEMAIL function

ISEMAIL(address) ISEMAIL(address)

address — Text or { Text }

The potential email address.

Returns — Logical or { Logical }

Whether the given text string is probably an email address.

Returns whether the given text string is probably an email address. ISEMAIL("support@calcapp.net")ISEMAIL("support@calcapp.net") returns TRUE, but ISEMAIL("support at calcapp.net")ISEMAIL("support at calcapp.net") returns FALSE.

This function uses the same technique that web browsers use when determining if an input email field is valid. It does not strictly conform to the standard dictating what email addresses may and may not contain, for practical reasons.

This function is specific to Calcapp.

Examples

ISEMAIL("support@calcapp.net")ISEMAIL("support@calcapp.net")

Returns TRUE.

ISEMAIL("support at calcapp.net")ISEMAIL("support at calcapp.net")

Returns FALSE.

AND(ISEMAIL(EmailField1:EmailField10))AND(ISEMAIL(EmailField1:EmailField10))

Returns TRUE if all text fields covered by the EmailField1:EmailField10EmailField1:EmailField10 range contain valid email addresses. ISEMAIL(EmailField1:EmailField10)ISEMAIL(EmailField1:EmailField10) returns a logical array containing the results for all email fields. AND is then applied to this logical array and returns TRUE only if all the elements of the logical array are TRUE.

AND(ISEMAIL(UserName1:UserName10 & "@example.com"))AND(ISEMAIL(UserName1:UserName10 & "@example.com"))

Returns TRUE if all text fields covered by the UserName1:UserName10UserName1:UserName10 range contain valid email addresses, when their values are joined together with "@example.com". In other words, the fields of the UserName1:UserName10UserName1:UserName10 range are expected to contain user names, which appear on the left-hand side of the "@" sign. The & operator then appends "@example.com" to the values of all fields, before this array with email addresses is fed to ISEMAIL. It returns a logical array containing the results for all email addresses. Finally, AND is applied to this logical array and returns TRUE only if all the elements of the logical array are TRUE.