How to formulate a multiple if/then/else statement?

I’m trying to formulate a logical function that depends on a “Choice” field.

If ChoiceType =1, then I want to display the result of Formula_1

If ChoiceType =2, then I want to display the result of Formula_2

If ChoiceType =3, then I want to display the result of Formula_3

If none of these choices are selected, I want to display “Not Assigned”

Here is the basic formula I’ve been trying to use:

if ChoiceType = 1 then FormulaI_1

if ChoiceType = 2 then FormulaI_2

if ChoiceType = 2 then FormulaI_3

else “Not Assigned”

end

I have also tried using “or” and “and” between each condition, but it isn’t working. Can you please help?

- Nick
- 5 yrs ago
- Reported - view
Try this:

if ChoiceType = 1 then FormulaI_1

else

if ChoiceType = 2 then FormulaI_2

else

if ChoiceType = 2 then FormulaI_3

else “Not Assigned”

end
- Yoyo_Gam
  
  5 mths ago
  
  Reported - view
  Is it possible to reverse the operation so that a formula field can choose under changing conditions the appearance of the corresponding button among the 3 buttons?
- wstarnes
- 5 yrs ago
- Reported - view
Fantastic!!

THANK YOU!!
- englishatnoil
- 2 yrs ago
- Reported - view
This work for me too , thank a lot

Content aside