WashingtonDC
New Member
- Joined
- Sep 19, 2016
- Messages
- 12
Good afternoon,
I am trying to generate a score based on responses with values from 1-3. For example: I have three categories: on track, off track, and N/A. I would like to generate an "IF" statement where "on track"=3, "off track"=1 and "N/A"=0. This will be pulling from a pick list from another tab in the workbook.
Additionally, I need to calculate an aggregate score with "total values"/"total possible values". For example: if people have filled out 10 columns with the above options I need to sum the scores for each of those, and then divide it by total possible points (which will be 30- 3 times the 10 columns). Is there a way to write a formula that is versatile that if people fill out 10 columns or 50 columns it will calculate the correct value?
Thanks!
I am trying to generate a score based on responses with values from 1-3. For example: I have three categories: on track, off track, and N/A. I would like to generate an "IF" statement where "on track"=3, "off track"=1 and "N/A"=0. This will be pulling from a pick list from another tab in the workbook.
Additionally, I need to calculate an aggregate score with "total values"/"total possible values". For example: if people have filled out 10 columns with the above options I need to sum the scores for each of those, and then divide it by total possible points (which will be 30- 3 times the 10 columns). Is there a way to write a formula that is versatile that if people fill out 10 columns or 50 columns it will calculate the correct value?
Thanks!
