Score Sheet

[jkvarner15]

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.

 

[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.