Thread: Compute a score based off many variables

I'm having a hard time creating the math formula to make this project work.

Max possible points for each category are as follows:

Abdominal Circumference: 20 points
Pushups: 10 Points
Situps: 10 Points
Run Time: 60 Points

Any of the above may be exempt except the Abdominal Circumference. If any of the above are exempt then the math formula would be as follows:

(20 + Exp (pushups) + 10 + 60)/90*100 = 100

So for example a member scores 16 points for abdominal, Exempt from pushups, 8 points for situps and 48 points for run time it would look like:
16 + 8 + 48 = 72
(72/90)*100 = 80 points

Where I'm totally confused is how to write a formula that will test any exempt variable and produce the correct score. So in the above if a member is exempt from both pushups and situps but completes the run and abdominal I need to compute a score. Or in another example, exempt from the run but completes the other 3.

Is this possible to write a formula in one cell? I'm trying to create a table with all this so it can be sorted and used as a possible pivot. I created this before with another spreadsheet but had many differnet hidden cells to accomplish this. I'd like to run all possible variables in the "Score" cell instead of having hidden cells.

Thanks in advance. I'll rep all that can help with this.