
Creator
2022-03-30
06:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Multiple IF Statements?
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
Labels (6)
Labels
- Subscribe by Topic:
-
Data Load Editor
-
Developers
-
dimension
-
expression
-
General Question
-
Script
1,284 Views
1 Solution
Accepted Solutions


MVP
2022-03-30
06:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
1 Reply


MVP
2022-03-30
06:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
