Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Magic Trick #111: Build A Questionnaire

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
25,236
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Oct 10, 2008

See how to put the IF function inside a VLOOKUP function, add Data Validation, use an Array formula, unlock cells and protect the sheet all in order to create a Questionnaire form that automatically tallies the score. Protection Lock cells Unlock Cells Protect.

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (ExcelIsFun)

  • Suppose you created a questionnaire with dropdown lists for answer possibilities. If one of the possibilities is "other", that then requires the user to fill in an additional field which is only unlocked with that option. Is that even possible?

  • I do not know about this topic. Try THE best Excel question site:

    mrexcel[dot]com/forum

  • where exactly is your website to download the xcel format? I went on your you tube channel, but no dice//?

  • Watch the vid that auto plays at the channel - it shows how to download.

see all

All Comments (11)

Sign In or Sign Up now to post a comment!
  • Suppose you created a questionnaire with drop-down lists for answer possibilities. If one of the possibilities is "other", that then requires the user to fill in an additional field which is only unlocked with that option. Is that even possible?

  • Can i use this code for a question for more than just A or B? like i wanted to make the possible answers to be "a,b,c,e,f,g)?

  • Can i use this code for a question for more than just A or B? like i wanted to make the possible answers to be "a,b,c,e,f,g)?

  • Yeah, because most tramps are indeed learned in the arts of Excel. In fact, the tramp population are so fluent with Excel that in no time they have flawlessly executed spreadsheets to calculate their daily begging income and expenditure for venues, tip-cut-off gloves and patchy hobo jackets.

    Anyway, I'd be using the IFERROR formula too much for Psychology, too many nutcases, too much error. :D.

  • Psychological? A lot of stats! That means lots of Excel.

    Patch of concrete? You still need a spreadsheet to track all the money you will bring in!

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more