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
|
|
|
|
|
|
|