4 IFs

[Steve]

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

 

[Glenn]

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<=2000),3,
IF(AND(A1>=1,A1<=2400),1,"Not between 1 and 2400")))

 

[Don Guillett]

Play with this
=IF(J12>2400,"",IF(J12>2000,1,IF(J12>1200,3,IF(J12>400,2,IF(J12>0,1,"")))))

 

[Jacob Skaria]

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

 

[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