jkvarner15
New Member
- Joined
- Apr 18, 2018
- Messages
- 3
B | C | D | E | F | G | H | I | J | K | Q | R | S | T | U | V | ||||||
3 | Sit and Reach | Sit-ups | Push-ups | Run | Sit and Reach | Sit-ups | Push-ups | Run | Final Score | ||||||||||||
4 | 10.5 | 65% | 30 | 65% | 20 | 65% | 0:17:29 | - | 0:17:15 | 65% | Subject 1 | ||||||||||
5 | 11 | 66% | 31 | 66% | 21 | 66% | 0:17:14 | - | 0:17:00 | 66% | Subject 2 |
<tbody>
</tbody>
This is the score sheet that I have created. I am trying to create a formula that allows me to plug the exact number of repetitions per event, directly into ex. Cell R4-U4 and have V4 automatically calculate the score into a percentage. I understand I can plug the percentage earned from each event into R4-U4 and I know the formula to have V4 automatically calculate. I am just trying to plug in the scores to do the same.