Multiple if in straight table expression

[#1]

=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

[sunny_talwar]

Try this:

Sum(Pick(Match([Descriptive Analysis Response], 'Beginner', 'Applying', 'Expert'), 2, 3, 5))

[#3]

Wow, It worked Thanks a lot

[sunny_talwar]

Awesome

Please close the thread since you got what you were looking for