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
|
|