Which formula should I use and is this even possible?
I am trying to write a formula that will determine someone's risk level based off a number system. The risk level will either be 0, 1, or 2/3. I would like a formula that could take someone's answer to three "Yes" or "No" questions and add them together to show their risk level. The "No" would be worth 0 and the "Yes" would be worth 1. Is there a way I can make the Yes/No's worth those values and in turn add up using a formula in the "Risk Level" column? I could also change the Yes/No drop downs to a checkbox if that would be the only way for this to be possible.
Help Article Resources
Check out the Formula Handbook template!