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

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

=IF(AND(A1=401,A1<=1199),2,IF(AND(A1=1200,A1<=20 00),3,
IF(AND(A1=1,A1<=2400),1,"Not between 1 and 2400")))

Play with this
=IF(J122400,"",IF(J122000,1,IF(J121200,3,IF(J12 400,2,IF(J120,1,"")))))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
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

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

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