Multiple IF Statements?

[David_K]

Hi all,

I have a column of data that shows ratings as 'A' thru 'F', but I need to show them with a comment:

A - Excellent / B - Good / C - Average etc.

I have tried IF, AND, as well as IF, OR but still cannot get a workable solution

In another applications I would "IF, THEN, ELSEIF"

Hoping I ca get some guidance here.

Many thanks in advance

[Or · Accepted solution]

If(Column1='A','A - Excellent','if(Column1='B','B - Excellent',...))

You could also use Pick/Match to achieve the same result without the nested if() statements.