ISUPPER

The ISUPPER function tests a text object to determine whether it contains all uppercase alphabetic characters.

Syntax:
ISUPPER (series-text-expression)
Meaning:
ISUPPER (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 uppercase alphabetic characters (for example, A-Z), ISUPPER evaluates to "true".

If text_to_test contains other than uppercase alphabetic characters, ISUPPER returns "false".

Examples

  • IF(ISUPPER ( "BOMBAY" ))

    Returns "true"

  • IF(ISUPPER ( "CD-ROM" ))

    Returns "false"

  • IF(ISUPPER ( "Map Designer" ))

    Returns "false"

Related functions

  • ISALPHA
  • LEAVEALPHANUM
  • ISLOWER
  • LEAVENUM
  • ISNUMBER
  • LEAVEPRINT
  • LEAVEALPHA