Count if Lower case

T

THE_RAMONES

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

Thanks for the help
 
M

Marcelo

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:
 
M

Marcelo

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:
Click to expand...
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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