Excel Case Formula (if/then)

[mcmuney]

There's a simple case formula to determine if a cell characters all uppercase, lowercase or mixed, but I can't seem to find it. Anyone know the formula?

[sglife]

I think this is what you need

for the text in cell A1

=IF(EXACT(A1,UPPER(A1)),"Uppercase",IF(EXACT(A1,LOWER(A1)),"Lowercase","Mixed"))

[mcmuney]

That's in... thanks