Help with percentage formulas for Physical Fitness Test

**neilcarilla** · 09-01-2012, 08:00 AM

Hey everybody,

The attached sheet is a scorecard for a physical fitness test that I recently conducted. I am fine with entering the data in by hand, but I was wondering if there was a formula that could calculate the numbers for me. The number at the top of the column in parenthesis is the score that will give you 100%, the number beside that with the plus sign is the extra points you get for each repetition over the number in parenthesis.

For example: The first soldier could only do one repetition in the bench so he only gets 10%

The second soldier did 16 repetitions so gets 100% plus six times the six bonus points equaling 136 points for that event.

I am fairly new at excel and was able to do the sums myself, but the formula for the above seems pretty complicated. Thanks for any help in advance.

-Neil

**oeldere** · 09-01-2012, 08:52 AM

I get an differant answer for I4 en C (golden cells).

Please reply if this is what you''re up to.

Do you have questions on this item, just ask.

**neilcarilla** · 09-01-2012, 11:19 AM

That was almost what I needed. I changed the very last part to this:

=IF(B4>B$1,100+(B4-B$1)*B$2,B4/B$1%)

Just to get the percentage if they didn't make it to 100%. That was very helpful though. It gave me a better understanding of the IF. Thanks!

-Neil