IF Formula

Brittany Johnson

My goal is to return two potential values depending on what is selected in a multi-select column (Named: [VA...DBQ Worksheet] ).

The dropdowns are:

Service Connected Diagnosis Blank

Service Connected Diagnosis Incomplete (Rated as vs. Contention Name)

Bilateral Indicator

ICD Code

If any of the first three are selected I want the result to return as "Miss". If the ICD Code dropdown is the only thing selected, I want it to return "On Target". If nothing is selected, just return blank.

I'm thinking it would be some form of a nested IF and OR formula? My brain is stuck.

Toufong Vang

Hi, @Brittany Johnson , you would use a nested IF() formula. IF(NN="", "", IF( NN="ICD Code", "On Target", "Miss")).

=IF([multi-select column]@row = "", "", IF([multi-select column]@row = "ICD CODE", "On Target", "Miss"))