dreinisch
New member
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","")))))
=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","")))))