Would be very beneficial to see how this formula is used and what results it generated.
Would be very beneficial to see how this formula is used and what results it generated.
Thank you. This is exactly what I was looking for!!
This is exactly what I was looking for. Thanks!!
Problem:
Determining whether each of the names in List1 (column A) are exclusively upper case, exclusively lower case, or a combination of both.
Solution:
Use the IF, EXACT, UPPER, and LOWER functions as shown in the following formula:
=IF(EXACT(A2,UPPER(A2)),\"Upper Case\",IF(EXACT(A2,LOWER(A2)),\"Lower Case\",\"Upper and Lower Case\"))
This is crazy but great!
I have no idea for what purposes this can be but I love it.
Frank
Frank
[email protected]
applied very good logic.
Simple formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks