+ Reply to Thread
Results 1 to 6 of 6

IF function. How to substitute depending on condition in another text box

  1. #1
    Registered User
    Join Date
    11-15-2017
    Location
    Rugby, England
    MS-Off Ver
    2010
    Posts
    4

    IF function. How to substitute depending on condition in another text box

    Hi there,

    Can someone help me out please?

    How do i create this function:

    If text in box C1 has an underscore then substitute fullstop in D1 with PT0

    Thankyou

  2. #2
    Registered User
    Join Date
    11-15-2017
    Location
    Rugby, England
    MS-Off Ver
    2010
    Posts
    4

    Re: IF function. How to substitute depending on condition in another text box

    This is what I got so far but doesn't work.

    =IF(C4,"*_*"(=SUBSTITUTE(E4,".",".PT0.")),(=SUBSTITUTE(E4,".",".MAIN.")))

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,274

    Re: IF function. How to substitute depending on condition in another text box

    Try

    =IF(ISNUMBER(SEARCH("_",C4)),SUBSTITUTE(E4,".",".PT0."),SUBSTITUTE(E4,".",".MAIN."))

  4. #4
    Registered User
    Join Date
    11-15-2017
    Location
    Rugby, England
    MS-Off Ver
    2010
    Posts
    4

    Re: IF function. How to substitute depending on condition in another text box

    IT WORKS! Fantastic Mr Topley. Thank you

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    20,274

    Re: IF function. How to substitute depending on condition in another text box

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  6. #6
    Registered User
    Join Date
    11-15-2017
    Location
    Rugby, England
    MS-Off Ver
    2010
    Posts
    4

    Re: IF function. How to substitute depending on condition in another text box

    Thankyou again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Substitute formula condition from to text with numerical
    By silambarasan.J in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-25-2016, 05:41 PM
  2. [SOLVED] Need a formula to find and substitute a word in a text if a condition is met...
    By danielneedssomehelp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-18-2014, 01:34 PM
  3. [SOLVED] Issues recognizing text and counting the cell depending on a condition
    By trotamundo in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-15-2014, 05:01 PM
  4. [SOLVED] Change color of text depending on condition using vba
    By jacob@thepenpoint in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2012, 09:08 AM
  5. How to use a substitute formula to substitute text entries to a different text entry
    By andybocchi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-01-2010, 07:50 PM
  6. Replies: 5
    Last Post: 11-16-2009, 08:24 AM
  7. [SOLVED] applying function depending on condition in other cell
    By jonnegoogle@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2005, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1