Remember Me?

#1
July 18th 12, 05:08 PM
 Junior Member First recorded activity by ExcelBanter: Jul 2012 Posts: 3
IF-MID Function

I need a formula that copies the text into my cell when my =MID(A25,11,2) position is "EA" or "E6" as the value. I need that EA or E6 to copy into the cell. So the formula would look at the MID position...if its EA or E6 then copy, if not then leave it blank. PLease help!

#2
July 18th 12, 08:05 PM
 Senior Member First recorded activity by ExcelBanter: Mar 2012 Posts: 663

Quote:
 Originally Posted by ROBERT0803 I need a formula that copies the text into my cell when my =MID(A25,11,2) position is "EA" or "E6" as the value. I need that EA or E6 to copy into the cell. So the formula would look at the MID position...if its EA or E6 then copy, if not then leave it blank. PLease help!
Hi,

Does the below formula do what you mean?

=IF(OR(MID(A25,11,2)="EA",MID(A25,11,2)="E6"),MID( A25,11,2),"")
#3
July 18th 12, 08:40 PM
 Junior Member First recorded activity by ExcelBanter: Jul 2012 Posts: 3

Quote:
 Originally Posted by Spencer101 Hi, Does the below formula do what you mean? =IF(OR(MID(A25,11,2)="EA",MID(A25,11,2)="E6"),MID( A25,11,2),"")
You rock. worked great.
#4
July 18th 12, 08:42 PM
 Senior Member First recorded activity by ExcelBanter: Mar 2012 Posts: 663

Quote:
 Originally Posted by ROBERT0803 You rock. worked great.

Glad to help! But yes, I do ROCK!
#5
July 18th 12, 08:53 PM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,785
IF-MID Function

Hi Robert,

Am Wed, 18 Jul 2012 16:08:55 +0000 schrieb ROBERT0803:

I need a formula that copies the text into my cell when my
=MID(A25,11,2) position is "EA" or "E6" as the value. I need that EA or
E6 to copy into the cell. So the formula would look at the MID
position...if its EA or E6 then copy, if not then leave it blank. PLease
help!

try:
=IF(OR(MID(A25,11,2)={"EA","E6"}),MID(A25,11,2),"" )

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post SteveM Excel Programming 1 January 3rd 08 03:45 PM oaallam Excel Discussion (Misc queries) 4 September 6th 07 01:20 PM [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM BruceInCalgary Excel Programming 3 August 23rd 06 08:53 PM [email protected] Excel Programming 0 June 20th 06 03:53 PM

All times are GMT +1. The time now is 03:28 AM.