ISLOWER

The ISLOWER function tests a text object to see if it contains all lowercase alphabetic characters.

Syntax:
ISLOWER (series-text-expression)
Meaning:
ISLOWER (text_to_test)
Returns:
This function evaluates to a Boolean "true" or "false" and should only be used as a conditional expression within a logical function.

If text_to_test contains only lowercase alphabetic characters (for example, a-z), ISLOWER evaluates to "true".

If text_to_test contains other than lowercase alphabetic characters, ISLOWER returns "false".

Examples

  • IF(ISLOWER ("company"))

    Returns "true"

  • IF(ISLOWER ("pots and pans"))

    Returns "false"

  • IF(ISLOWER ("Andrew"))

    Returns "false"

Related functions

  • ISALPHA
  • LEAVEALPHANUM
  • ISNUMBER
  • LEAVENUM
  • ISUPPER
  • LEAVEPRINT
  • LEAVEALPHA