Have [Tier] column with choice values of 0,1,2,3.
If [Tier] = 0 calculated column should = 0
If [Tier] = 1 calculated column should = 4
If [Tier] = 2 calculated column should = 24
If [Tier] = 3 calculated column should = 48
Can get to work for 2 values using the following syntax but not for 4 values:
=IF(OR([Tier]="1",[Tier]="2"),"4","24")