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?
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?