View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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