+ Reply to Thread
Results 1 to 4 of 4

IF function combined with another IF function question

  1. #1
    Registered User
    Join Date
    08-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    20

    IF function combined with another IF function question

    So I have the formula listed below, and what shows up. I want to add the & symbol at the beginning of the function and have it add to whatever number the IF statement I have listed below happens to come out as.

    =IF(C1="","",IFERROR(CHOOSE(LEN(C1)-LEN(SUBSTITUTE(C1,"*","")),14,16,18,20,22),12))

    Example of what is in cell C1 and the output:

    _____________
    M3848 ***|18|
    ---------------
    Another Example:
    __________
    M3848 *|14|
    ------------

    And here is what I want to happen, where & = 4
    ______________
    &M3848 ***|22|
    ----------------
    Another Example:
    ___________
    &M3848 *|18|
    -------------

    How can I make this happen?
    Last edited by Nexion21; 09-06-2013 at 03:24 PM.

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: IF function combined with another IF function question

    ooops.. ITS REALLY HARD to guess what you want to say... thank god.. My system has "MindReader V1.2 (beta)" version installed..

    try this..

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BTW.. for 1st part you can use..
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Registered User
    Join Date
    08-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: IF function combined with another IF function question

    Thanks Debraj Roy! Your MindReader V1.2 worked wonderfully I just had to switch the 0 and the 4 around.

  4. #4
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: IF function combined with another IF function question

    Thanks for the feedback and switching True False..

+ 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] Combined AND function not reading output of the function of another cell
    By Duoae in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2012, 09:22 AM
  2. Combined ARRAY and IF function
    By z3tls0 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-07-2010, 03:30 PM
  3. vlookup combined with AND-function
    By martho in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2006, 08:55 AM
  4. [SOLVED] Combined VLOOKUP AND BETWEEN FUNCTION
    By Louis Markowski in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2005, 11:05 AM
  5. vlookup / len function combined
    By jamesg-fid in forum Excel General
    Replies: 3
    Last Post: 03-10-2005, 12:06 PM

Tags for this Thread

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