Count if Lower case
 

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

Thanks for the help

Count if Lower case
 

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:

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

Thanks for the help

Count if Lower case
 

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:

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

Thanks for the help

Count if Lower case
 

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

--
HTH

Bob Phillips

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

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

Thanks for the help

Count if Lower case
 

Hi!

Try this:

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

Biff

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

Thanks for the help