IF Clause

[joslaz]

Hello everyone,

I have the following tabel:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Dep[/TD]
[TD]Area[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A3[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A4[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A5[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A15[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A16[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A20[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]A21[/TD]
[/TR]
</tbody>[/TABLE]


Now I am Looking for a function for an calculated column (Power Pivot), which categorize the Area in the following groups
A1-A5 = AA
A15-A16 = AB
A20-30 = AC
A90-A100 = AD

How would you manage that?
A simple IF-Clause?


Best Regards
Joshua

 

[Matt Allington]

If you can’t change it at the source, then a calc column is fine. Try SWITCH as follows

=SWITCH(TRUE(),
table[column] in {“”A1,”A2”,”A3”,”A4”,”A5”}, “AA”,
table[column] in {“”A15,”A16”}, “Ab”,
etc
)

 

[joslaz]

It works perfecly! Thanks