sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
Is it possible to have a tick box (or alternative?) in a cell so when it is ticked it scores a number specific to that cell in an overall score. For example, if I have questions in column A and then 3 answers in column B, C and D that are tick boxes (i.e. with heading above them bei9ng Yes (column B), No (C) and N/a (D):
If, for example in the first row (i.e. 2) they tick the box in B2 (i.e. to answer yes to the question in A2) and I want ot allocated 3 points to that answer. Let's say the total score is in E1. So then they answer the next question in row 3 and they answer "Yes" by ticking the box in B3, however this time I want to allocate 2 points to this answer. When they tick this box the score in E1 increases automatically from 3 to 5. And so on....
Hope the concept makes sense. I can use vlookup in another sheet to allocate the scores to each row and answers but would like them to tick boxes or something that looks half tech savvy!
Thanks in advance
If, for example in the first row (i.e. 2) they tick the box in B2 (i.e. to answer yes to the question in A2) and I want ot allocated 3 points to that answer. Let's say the total score is in E1. So then they answer the next question in row 3 and they answer "Yes" by ticking the box in B3, however this time I want to allocate 2 points to this answer. When they tick this box the score in E1 increases automatically from 3 to 5. And so on....
Hope the concept makes sense. I can use vlookup in another sheet to allocate the scores to each row and answers but would like them to tick boxes or something that looks half tech savvy!
Thanks in advance