| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
