Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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
Try this:
Sum(Pick(Match([Descriptive Analysis Response], 'Beginner', 'Applying', 'Expert'), 2, 3, 5))
Wow, It worked Thanks a lot
Awesome
Please close the thread since you got what you were looking for