3 Replies Latest reply: Dec 23, 2015 12:44 PM by Sunny Talwar RSS

    Multiple if in straight table expression

      =sum(If([Descriptive Analysis Response]='Beginner',2,0))or

      if([Descriptive Analysis Response]='Applying',3,0)or

      if([Descriptive Analysis Response]='Expert',5,0)



      Actually i have survey responses like beginner, expert etc, for each questions.


      I want to sum up the response and give a weighted total.


      =sum(If([Descriptive Analysis Response]='Beginner',2,0)) this one works but rest of the if statement not working

      Please help