Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use spellnumber formula | Excel Worksheet Functions | |||
Currency to Text | Excel Worksheet Functions | |||
Loop for VBA code? | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |