Help with IF statement for % tied to specified value

Gaurav Chauhan

Hi Team, Can you please help me write a formulae wherein based on the user selection, the % score can be populated.

Not Met = 0%, Partially Met = 50%, Met = 100%, Not Applicable = Blank

Thanks.

DKazatsky2

Hi @Gaurav Chauhan,

Here is the formula.

=IF([KPI Measure]@row = "Not Met", 0, IF([KPI Measure]@row = "Partially Met", 0.5, IF([KPI Measure]@row = "Met", 1, "")))

Be sure to set the "Score" column to be a %.

Hope this helps,

Dave