Score Sheet

[jkvarner15]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[TD]U[/TD]
[TD]V[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Sit and Reach[/TD]
[TD][/TD]
[TD]Sit-ups[/TD]
[TD][/TD]
[TD]Push-ups[/TD]
[TD][/TD]
[TD]Run[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sit and Reach[/TD]
[TD]Sit-ups[/TD]
[TD]Push-ups[/TD]
[TD]Run[/TD]
[TD]Final Score[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10.5[/TD]
[TD]65%[/TD]
[TD]30[/TD]
[TD]65%[/TD]
[TD]20[/TD]
[TD]65%[/TD]
[TD]0:17:29[/TD]
[TD]-[/TD]
[TD]0:17:15[/TD]
[TD]65%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Subject 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]11[/TD]
[TD]66%[/TD]
[TD]31[/TD]
[TD]66%[/TD]
[TD]21[/TD]
[TD]66%[/TD]
[TD]0:17:14[/TD]
[TD]-[/TD]
[TD]0:17:00[/TD]
[TD]66%[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Subject 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.

 

[eikogs]

I am not positive I understand exactly what you are going for, especially for 'Run', but this might get you pointed in a direction you can make work. Try this in V4.

=IF(R4>=B4,C4,0)+IF(S4>=D4,E4,0)+IF(T4>=F4,G4,0)+IF(U4>=H4,K4,0)

 

[jkvarner15]

So basically, I am trying to find an equation or something to link B4 and C4, so when I put the number 10.4 in R4 it automatically switches to 65%. or I can add a column between R and S and if I put 10.5 into R4, S4 then automatically gives me the percentage. That would work too.

 

[jkvarner15]

10.5 not 10.4, sorry. New and don't know how to edit comment.