View Single Post
  #7   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default getting XL to recognize lower from upper case in IF formula

=IF(EXACT(MID(A1,3,1),LOWER(MID(A1,3,1))),"lower", "upper")

--
Jim
"stef" wrote in message
...
| Thanks.
| Actually, come to think of it, if I could have a formula that does if 3
| letter of D3 is lower case, then divide by 50--that would be the best.
| Is there a way to define "lower case" in 3rd position?
|
| Niek Otten wrote:
| Use the EXACT() function
|