Ok, so the conditions are this:

Males 26 and under have a run time of 18 minutes or less for a perfect 100
points. For every 10 seconds after that you subtract 1 point (so that a run
time of 18:01 - 18:10 = 99 points and a run time of 23:00 = 70 points)
Anything 28:01 and over is failing.

Males 27 to 39 have same perfect score but 29:01 and over is failing.

Males 40 - 45 have until 30:01 to pass.

Males 46 and over have until 33:01 to pass.

That's one. The other conditions a

Females 26 and under run a 21:00 or faster for 100 points. Same subtraction
rate for points. 31:01 is failing point.

Females 27 - 39 have till 32:01 and females 40 - 45 have until 33:01 to pass.

Females 46 and over have until 36:01.

I have the beginning I think. Here is what I have so far that I could figure
out:

L8 is my Age block, M8 is my Gender block, and Y8 is my run time block. AA
is the run score block.

=(--(L8<27)*(M8="M"))*IF(Y8<=1800,100

I hope the beginning I have can help someone to help me lol. Thanks in
advance to anyone who can help this jumble out.