=IF(UPPER (A1);LOWER; (A1))

C

ceylan

If A1 is uppercase B1must be lower if not it must remain uppercase please
help for this formula thank you
 
A

AdamV

In B1:
=IF(UPPER(A1)=A1,LOWER(A1),A1)

should do it, if I understand your question correctly

If A1 might be mixed case and you want B1 to be always all upper or all
lower, maybe this is actually what you want:

=IF(UPPER(A1)=A1, LOWER(A1), UPPER(A1))
 
R

raju

Dear Sir,

in A1 ,HALOL LEATHER, I Want change it in B1 as Halol Leather
who it possible.
raju
mumbai
 
Top