The Grim Discovery
Board Regular
- Joined
- Jan 23, 2015
- Messages
- 241
- Office Version
- 365
- Platform
- Windows
People
I've got this scenario and I've been scratching my head over this for a while today.
It's a small survey of 11 participants (b1) who were asked to answer a question.
4 got the answer right (B2), 5 got it wrong (B3) 1 spoiled the paper (B4) but, and this is what's catching me out, 1 didn't answer. I need to be able to add that 1 to the total of B3 (making it a new total of 6). But can I do this without adding another cell of data ie. can I calculate this using only the values in B1:B4. My efforts in formulating this so far have only resulted in circular reference warnings and wrong answers. Maybe it cant be done. Maybe I'm missing something obvious. Thanks as ever.
<tbody>
</tbody>
I've got this scenario and I've been scratching my head over this for a while today.
It's a small survey of 11 participants (b1) who were asked to answer a question.
4 got the answer right (B2), 5 got it wrong (B3) 1 spoiled the paper (B4) but, and this is what's catching me out, 1 didn't answer. I need to be able to add that 1 to the total of B3 (making it a new total of 6). But can I do this without adding another cell of data ie. can I calculate this using only the values in B1:B4. My efforts in formulating this so far have only resulted in circular reference warnings and wrong answers. Maybe it cant be done. Maybe I'm missing something obvious. Thanks as ever.
A | B | |
1 | Total number | 11 |
2 | Correct | 4 |
3 | Incorrect | 5 |
4 | Spoiled | 1 |
5 | ||
<tbody>
</tbody>