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

[Guest]

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

 

[Guest]

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))

 

[raju]

Dear Sir,

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

 

[Dave Peterson]

=proper(a1)

May work for you.

Dear Sir,

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