Thanks guys,

All worked well. I did have a bit of a problem, but it was originally due to
the way my imported data was formatted. I was able to fix it, so thanks again.

Steve

"Jacob Skaria" wrote:

Dear Steve

When you have more conditions use LOOKUP...easy to edit..as below

=LOOKUP(A1,{0,1,401,1200,2001,2401},{"",1,2,3,1,"" })

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

How can 4 ifs give me one of 3 numbers in the following situations:

If between 1200-2000, = 3
If between 2001-2400, = 1
If between 0001-0400, = 1
If between 0401-1199, = 2

Thanks,

Steve