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