If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 IF-MID Function
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## IF-MID Function

#1
July 18th 12, 05:08 PM
 ROBERT0803 Junior Member First recorded activity by ExcelBanter: Jul 2012 Posts: 2
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
 Spencer101 Senior Member First recorded activity by ExcelBanter: Mar 2012 Posts: 654

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
 ROBERT0803 Junior Member First recorded activity by ExcelBanter: Jul 2012 Posts: 2

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
 Spencer101 Senior Member First recorded activity by ExcelBanter: Mar 2012 Posts: 654

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
 Claus Busch external usenet poster Posts: 937
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

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? SteveM Excel Programming 1 January 3rd 08 03:45 PM copy of excel file not showing formulal/function in the function b oaallam Excel Discussion (Misc queries) 4 September 6th 07 01:20 PM LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM Excel - User Defined Function Error: This function takes no argume BruceInCalgary Excel Programming 3 August 23rd 06 08:53 PM Need to open the Function Arguments window from VBA for a user defined function. [email protected] Excel Programming 0 June 20th 06 03:53 PM

All times are GMT +1. The time now is 10:37 AM.