Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
jezzica85
 
Posts: n/a
Default One more formula question--adding LOWER

My formula, thanks to everyone's wonderful help, has now evolved to:

=IF(LEFT(A1)="#",MID((UPPER(MID(A1,1,2))&LOWER(MID (A1,3,255))),2,255),IF(LEFT(A1)="%",UPPER(MID(A1,2 ,255))))

I'd like to add LOWER(A1) in there somehow, so if neither of these two
conditions are met, it doesn't display "false," but it converts everything in
cell A1 to lowercase. I've tried lots of things and nothing seems to work,
please help me out one more time, I'd be forever grateful! Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default One more formula question--adding LOWER

=IF(LEFT(A1)="#",MID((UPPER(MID(A1,1,2))&LOWER(MID (A1,3,255))),2,255),
IF(LEFT(A1)="%",UPPER(MID(A1,2,255)),
IF(EXACT(A1,LOWER(A1)),LOWER(A1))))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jezzica85" wrote in message
...
My formula, thanks to everyone's wonderful help, has now evolved to:


=IF(LEFT(A1)="#",MID((UPPER(MID(A1,1,2))&LOWER(MID (A1,3,255))),2,255),IF(LEF
T(A1)="%",UPPER(MID(A1,2,255))))

I'd like to add LOWER(A1) in there somehow, so if neither of these two
conditions are met, it doesn't display "false," but it converts everything

in
cell A1 to lowercase. I've tried lots of things and nothing seems to

work,
please help me out one more time, I'd be forever grateful! Thanks!



  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default One more formula question--adding LOWER

Hi Jessica

Try
=IF(LEFT(A1)="#",
MID((UPPER(MID(A1,1,2))&LOWER(MID(A1,3,255))),2,25 5),
IF(LEFT(A1)="%",
UPPER(MID(A1,2,255),
LOWER(A1))))

--
Regards

Roger Govier


"jezzica85" wrote in message
...
My formula, thanks to everyone's wonderful help, has now evolved to:

=IF(LEFT(A1)="#",MID((UPPER(MID(A1,1,2))&LOWER(MID (A1,3,255))),2,255),IF(LEFT(A1)="%",UPPER(MID(A1,2 ,255))))

I'd like to add LOWER(A1) in there somehow, so if neither of these two
conditions are met, it doesn't display "false," but it converts
everything in
cell A1 to lowercase. I've tried lots of things and nothing seems to
work,
please help me out one more time, I'd be forever grateful! Thanks!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question about the "Match" formula Ltat42a Excel Discussion (Misc queries) 3 February 22nd 06 12:56 AM
I have a question regarding countif formula. Fahad Farid Ansari Excel Worksheet Functions 6 October 1st 05 11:57 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't Damaeus Excel Worksheet Functions 12 January 23rd 05 05:52 PM


All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"