Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 18th 12, 05:08 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 3
Default 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   Report Post  
Old July 18th 12, 08:05 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by ROBERT0803 View Post
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   Report Post  
Old July 18th 12, 08:40 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 3
Default

Quote:
Originally Posted by Spencer101 View Post
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   Report Post  
Old July 18th 12, 08:42 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

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

Glad to help! But yes, I do ROCK!
  #5   Report Post  
Old July 18th 12, 08:53 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,729
Default 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


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
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? SteveM Excel Programming 1 January 3rd 08 04: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 05:07 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017