Creating formulas in Numbers

Hi Betsy,

Yes there is a formula for that. I don't know quite what you want though. Do you want a sheet that says if you want to cover 1000 meters in 6 minutes you have to be past 200 meter at such a time, 400 meters at such a time, etc.? or something else? Having the top row display times confuses me.

quinn

Betsy,

If the 6 minute pace is for a mile (I'm just guessing) then that defines how far a runner runs any fixed distance.

Here is a way to do this:

B5 contains the distance over which you want to get the check points and

B6 contains the duration over which a runner needs to cover the distance (duration means enter as "6m 0s" for 6 minutes 0 seconds)

row 1 contains checkpoints numbers 0 through 8

B2=B1×$B$5÷MAX(1:1)

this is shorthand for select cell B2 then type (or copy and paste from here) the formula:

=B1×$B$5÷MAX(1:1)

select cell B2, copy, select cells B2 thru J2, paste

B3=B2÷($B$5÷DUR2SECONDS($B$6))

select cell B2, copy

select cells B2 thru J3, paste

the results in row three are in seconds

Hi Betsy,

After sleeping on it, here is my solution. You need to specify a total distance- it can be whatever you want. You can add columns if you want to compare different times. You can add rows ifyou want greater distances.

you see the formula in B5, it is filled down and then across.

I made these choices as to the Duration format in B3, C3:

quinn