letter case?

[Guest]

How might I create an IF formula to recognize whether text in a column is
lower or upper case so that the text-related values may be added or
subtracted based on the case of the text? For example, I have text in B1:B50
whose complimenting values I would like to + or - from the values attributed
to the text in D150 depending on the case of that text.

 

[Guest]

If there is a single character in A1 then:

=IF(AND(CODE(A1)>64,CODE(A1)<91),"upper","lower")

 

[Bob Phillips]

You can test it like so

=EXACT(B1,LOWER(B1))

or

=EXACT(B1,UPPER(B1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

How about for all caps?

If there is a single character in A1 then:

=IF(AND(CODE(A1)>64,CODE(A1)<91),"upper","lower")

 

[Guest]

Allow me to clarify my ? -- the text is ALL CAPS vs Capitalized (not entirely
lower case). Is it possible?

 

[Guest]

Bob Phillips has the correct approach:

=IF(EXACT(A1,UPPER(A1)),"all upper",IF(EXACT(A1,LOWER(A1)),"all
lower","mixed"))