I am trying to add a condition to a selection formula using an If Then statement.

"KT/V DAUGIRDAS", "KT/V (DAUGIRDAS))", & "KT/V - [DOQI-DG]" are 3 possible values from the PATIENT_LAB_RESULTS.FOREIGN_ANALYTE_DESCRIPTION table. For the purposes of this report, I want them all to just show as "KT/V DAUGIRDAS"

What I have written is:

if ({PATIENT_LAB_RESULTS.FOREIGN_ANALYTE_DESCRIPTION} = "KT/V DAUGIRDAS", "KT/V (DAUGIRDAS))", "KT/V - [DOQI-DG]" then "KT/V DAUGIRDAS" else
{PATIENT_LAB_RESULTS.FOREIGN_ANALYTE_DESCRIPTION}

I am getting errors when I check the formula about missing commas or a boolean being required.

Thanks for your help. When I place the first example you wrote and check the formula by clicking the "X-2" button, I get an error that "The ) is missing" and on the formula the word "then" is highlighted in blue. I get the same if I use the 2nd or longer example.

I tried adding a close parenthesis right before "Then" but when I check the formula after doing so, I get a error "A boolean is required here." And the entire formula is highlighted in blue.

Thanks again. Yes, FOREIGN_ANALYTE_DESCRIPTION is a string.
I added the statement without the left paranthesis to the existing select statement and now it's giving me a message that "A boolean is required here." With the the entire new statement highlighted in blue.

Here is the original select statement:
{PATIENT_LAB_RESULTS.FACILITY_CODE} = {?Facility Number} and
{PATIENT_LAB_RESULTS.LAB_TEST_RESULT} <> "****" and
{MIMS_USER.MIMS_USER_ID} = {?mimsuser} and
{PATIENT_LAB_RESULTS.LAB_DATE_TIME} in {?Start Date} to {?End Date} and
{PATIENT_LAB_RESULTS.PROCEDURE_CODE} in ["20908", "22704", "10835", "1096", "1142", "1220", "12303", "1367", "1375", "1471", "15351", "28728", "1470"] and
{MIMS_USER_FACILITY.FACILITY_CODE} = {?Facility Number} and
{MIMS_USER_FACILITY.ACTIVE_Y} = "Y"


I added "and" to the end of the original and then the statement the you wrote.