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)

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.
--
David Biddulph

"Josee" <(E-Mail Removed)> wrote in message
news:7A8D3258-CB3D-4380-A086-(E-Mail Removed)...
>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)