automate point system

J

Josee

I have seconds in column as reference ie: A1 = 00:00:06 -- I have to make
formula in which if a1<00:00:07 then cell =5 (round number) otherwise if cell
a1>00:00:07 but <00:00:14 then sum of cell =3 or if cell a1>00:00:14<00:00:25
then cell =2 or if cell a1>00:00:25 then cell =0 (tried several functions
but keep on getting error)
 
D

David Biddulph

It might have helped if you'd told us what you've tried, and what error you
got.

Was one of the formulae you tried
=IF(A1<TIME(,,7),5,IF(A1<TIME(,,14),3,IF(A1<TIME(,,25),2,0))) ?

Note that your spec doesn't define what you wanted if A1 *equals* 00:00:07
or 00:00:14 or 00:00:25, but you can adjust < to <= as required, or add
extra conditions if you really want to exclude those values and have a
separately specified result condition.
 
Top