letter case?
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.
|