|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th, 2009, 02:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
4 IFs
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 
|
|
#2
May 12th, 2009, 02:53 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
4 IFs
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")))
|
|
#3
May 12th, 2009, 03:05 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
4 IFs
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
|
|
#4
May 12th, 2009, 04:22 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
4 IFs
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
|
|
#5
May 12th, 2009, 09:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
4 IFs
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
