I am pulling options from a table of "1", "2" or "3" and cannot get the Iif statement to produce the results that I need. Please find the Iif statement below:
=IIf([lepamtpaid]=1, “Your premium bill will reflect this new premium amount.)”,(lepamtpaid = 2, “This lump sum amount will be deducted from your Social Security check. After this, your new premium amount will also be deducted from your monthly Social Security check."), ([lepamtpaid]=3, “[Employer Group Name] & " has agreed to pay " & [Part D Late Enrollment Append Amt] & ", the amount of your late enrollment penalty, on your behalf. If your coverage is terminated by you or " & [Employer Group Name] & ", or if " & [Employer Group Name] & " stops paying your late enrollment penalty, you will be responsible for paying that amount.")
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!