Count if Lower case

[Guest]

I'm trying to write an IF statement. If lower case then equal 1, if not
equal 0

Thanks for the help

 

[Guest]

Hi,

imagine your range are on A1:A10

so the formula could be:

=if(a1=mim($a$1:$a$10),1,0)

hope this helps
regards from Brazil
Marcelo

"THE_RAMONES" escreveu:

 

[Guest]

sorry

MIN not mim as i type

"Marcelo" escreveu:

Hi,

imagine your range are on A1:A10

so the formula could be:

=if(a1=mim($a$1:$a$10),1,0)

hope this helps
regards from Brazil
Marcelo

"THE_RAMONES" escreveu:

 

[Bob Phillips]

=--EXACT(A2,LOWER(A2))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Biff]

Hi!

Try this:

=AND(A1<>"",EXACT(A1,LOWER(A1)))*1

Biff