Hi All,

I'm a little bit of a noob but I can't seem to find my answer anywhere
so here it goes.
I'm in a sleep research lab. One of our experiments has an element
where we wake the
person with a tone that increases by 3db every 3 seconds over a total
of 33 seconds.

So with this data I'm trying to take a time variable form one column
and translate it into a categorical value in another.

Let me illustrate:
J4 is the clock time that we start the tone
K4 is the clock time that it wakes the person
L4 in the elapsed time it took to wake the person
(all of these work great, very basic stuff)
M4 is the category that L4 falls into based on elapsed time

so if L4 is =00:00:00 and <=00:00:03, M4 should = "3db"
or
if L4 is =00:00:03 and <=00:00:06, M4 should = "6db"

and so on through a total of 11 ranged conditions 3db-33db.

Thing is you can only nest 7 "IF" statements. So that's out.

Any help would be great, I am very much stuck.