Thread
:
Count if Lower case
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Biff
Posts: n/a
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
Reply With Quote