Scoring Database Choices


I’m like to score someone’s responses to a form, but don’t know where I’d start.

For example, I have a row with three choices: rock, pop, and jazz. Depending on the choice you make on the form it then gives you a score. Say I choose rock and it gives me a score: ‘cool’.

I’d then like to build on that with other choices. So the form might ask if I prefer CDs or records. I choose records, and it gives me an updated score linked to my original choice. I’m now ‘very cool’.

Does that make sense? And is it possible?


I think you just need a complex formula with a lot of IF() functions:


That’s really useful, thank you. It’s going to take some time to get these formulas right!