Bob Phillips has the correct approach:

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

--
Gary's Student


"pacent" wrote:

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


"Gary''s Student" wrote:

If there is a single character in A1 then:

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


--
Gary's Student


"pacent" wrote:

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 D1:D50 depending on the case of that text.