If Statment VERY Simple

HotNumbers2001 · May 3rd, 2002, 03:48 PM

Need the following... Comun A has the following numbers 1 through 100. Need to have column be return the following numbers.
IF colum A the number is between 0 through 10 then return 1, if the number is between 11 - 25, then return 2, etc.....

avo

NateO · May 3rd, 2002, 03:52 PM

Try:

=IF(A1<11,1,IF(A1<26,2,"etc…"))

Incidentally, how does this sequence make sense?

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-03 14:53 ]

Ricky Morris · May 3rd, 2002, 03:52 PM

=if(and(a1>0,a1<25),1,if(and(a1>25,a1<50),2,if...

NateO · May 3rd, 2002, 03:57 PM

Ricky, that doesn't work for case 2, but conceptually sound. I'm guessing your sequence grows by 5 every increment 10, 15, 20, 25 (I feel like I'm taking the SAT here). Try this:

=IF(A1<11,1,IF(A1<26,2,IF(A1<56,3,IF(A1<76,4,5))))

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-03 15:04 ]

Mark W. · May 3rd, 2002, 03:58 PM

=VLOOKUP(A1,{0,1;11,2;26,3;...},2)

[ This Message was edited by: Mark W. on 2002-05-03 14:59 ]

HotNumbers2001 · May 3rd, 2002, 04:02 PM

Thank you all for your great help..... You guys are really amazing....

NateO · May 3rd, 2002, 04:04 PM

Neat trick Mark. Kudos.

HotNumbers2001 · May 3rd, 2002, 04:04 PM

thank you all for the help.... each of them works in a different way, but they all work.

May 3rd, 2002, 03:52 PM	#3
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	=if(and(a1>0,a1<25),1,if(and(a1>25,a1<50),2,if... __________________ It's never too late to learn something new. Ricky

May 3rd, 2002, 04:04 PM	#7
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Neat trick Mark. Kudos. __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 03:48 PM	#1
HotNumbers2001 Board Regular Join Date: Apr 2002 Posts: 139	Need the following... Comun A has the following numbers 1 through 100. Need to have column be return the following numbers. IF colum A the number is between 0 through 10 then return 1, if the number is between 11 - 25, then return 2, etc..... avo

May 3rd, 2002, 03:57 PM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Ricky, that doesn't work for case 2, but conceptually sound. I'm guessing your sequence grows by 5 every increment 10, 15, 20, 25 (I feel like I'm taking the SAT here). Try this: =IF(A1<11,1,IF(A1<26,2,IF(A1<56,3,IF(A1<76,4,5)))) _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-03 15:04 ]

May 3rd, 2002, 03:58 PM	#5
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=VLOOKUP(A1,{0,1;11,2;26,3;...},2) [ This Message was edited by: Mark W. on 2002-05-03 14:59 ]

May 3rd, 2002, 04:02 PM	#6
HotNumbers2001 Board Regular Join Date: Apr 2002 Posts: 139	Thank you all for your great help..... You guys are really amazing....