Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.