Results 1 to 4 of 4

Thread: IF Function Formula

  1. #1
    Seeker dreinisch's Avatar
    Join Date
    Sep 2011
    Troy, Missouri, United States

    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
    Utah, USA
    Excel Version
    Version 2002 Build 12527.20194
    You could use a vlookup to accomplish this.
    use this formula instead of what you have.

    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
    Adjust Source Code

    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

    =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
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Brussels Belgium
    Excel Version
    2010 on Xubuntu
    =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