I have a drop down in my form with 8 selections The drop down column name is Condition. I'm trying to use a calculated value to assign a numeric value to each of the 8 selections.
For example -
Item 1 (1 pt)
Item 2 (2 pts)
Item 3 (3 pts)
etc. . .
I'm using an IF statement to assign the values, but I can't seem to get it built correctly. Can someone show me the error of my ways?
Here's an example of the IF statement I'm trying to build -
If(Condition=='Item1','1',if(Condition=='Item2,'2'),if(Condition=='Item 3','3','0')))




