0

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") 
  • Thank you for the assist. I went with the Choose option but the "" are definitely required. – jmac Oct 11 '19 at 22:02
0

Option 1:

=CHOOSE([Tier]+1,0,4,24,48)

Option 2:

=IF(Tier=0,0,
     IF(Tier=1,4,
        IF(Tier=2,24,
             IF(Tier=3,48)
        )
      )
   )
| improve this answer | |
0

Option 1 given in @Mike Smith's answer will work fine.

But there is small problem with his Option 2. You will need to modify the formula in option 2 like below:

=IF([Tier]="0",0,
        IF([Tier]="1",4,
            IF([Tier]="2",24,
                IF([Tier]="3",48)
            )
        )
    )

Note the quotes(") used in formula for comparison.

References:

  1. CHOOSE function.
  2. IF function.

Calculated Column settings you want to use:

enter image description here

| improve this answer | |
  • I like the Choose option. Never would have got that syntax. Works perfectly!. Thanks! – jmac Oct 11 '19 at 22:02
  • Welcome. As this answer helped your, please upvote and accept it as an answer. – Ganesh Sanap Oct 12 '19 at 2:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.