Results 1 to 4 of 4

Thread: IF Function Formula

  1. #1
    Seeker dreinisch's Avatar
    Join Date
    Sep 2011
    Location
    Troy, Missouri, United States
    Posts
    9
    Articles
    0

    IF Function Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an IF Function Formula that will place in predetermined text into a cell based upon some parameters made in column C. Is there a way for the text to have multiple statements if column C has multiple letters? Right now only D,E,F,G or H can be entered....if two letters are entered into column C...even with a comma, nothing will display in the cell with the formula.


    =IF(C2="D","Account Requiring Assist Code Adjustment",IF(C2="E","Adjust Source Code,"IF(C2="F","Adjust LM Counselor",IF(C2="G","Adjust Plan Type",IF(C2="H","Email Assigned Host or Negotiator","")))))

  2. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    You could use a vlookup to accomplish this.
    use this formula instead of what you have.
    =vlookup(C2,table!$A$1:$B$5,2,false)

    this will look for the value in C2 from the sheet named table, and the range a1:b5.
    so table would look like
    columnA, columnB
    D, Account Requiring Assist Code Adjustment
    E,
    Adjust Source Code
    etc.

    the problem you will have with this method. is to get all of the scenarios you could have if you want to be able to have all 5 letters in the same cell would be 5^5 possibilities so your table is very large 3125 lines. And the letters would have to be entered exactly as they show in your table, no spaces or commas unless you put it that way in your table.



  3. #3
    Not sure if this is what you are looking for but give it a try and see. I'm assuming you are still wanting to use D,E,F,G,H as your Cell input. This formula would allow you to enter more than the single letter. For example you could enter Da1-2 in C2 and the formula will still display correctly.

    Do keep in mind your Cell input has to begin with your base input letters D,E,F,G,H


    Code:
    =IF(LEFT(C2,1)="D","Account Requiring Assist Code Adjustment",IF(LEFT(C2,1)="E","Adjust Source Code",IF(LEFT(C2,1)="F","Adjust LM Counselor",IF(LEFT(C2,1)="G","Adjust Plan Type",IF(LEFT(C2,1)="H","Email Assigned Host or Negotiator","")))))

  4. #4
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,359
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Perhaps
    Code:
    =IF(len(C2)>1,"",=CHOOSE(CODE(C2)-67,"Account Requiring Assist Code Adjustment","Adjust Source Code","Adjust LM Counselor","Adjust Plan Type","Email Assigned Host or Negotiator",""))
    Supposing letter is always entered in Uppercase

Tags for this Thread

Posting Permissions

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