Formulas in Number

Joined
Mar 23, 2011
Messages
3
Reaction score
0
Points
1
hello, not sure if this the right place for it but here goes.

im currently tracking my swim times in a numbers sheet, with charts etc. i have managed to get a formula that turns the duration into one number for the line chart BUT i need a formula that can look a these times and convert them into the points for each bracket - im currently manually inputting. what is the formula i need.

im guessing it is an =IF one, and i can get it to either show 0 or nothing but i really need one that covers everthing?

any help please?

Screen shot 2011-04-16 at 13.05.13.png
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top