Nested If Statement

[MJK]

I'm trying to write a nested if statement to extract dollar ranges from a column of data.

Example:

Dollar Amounts Less Than $50,000
Dollar Amounts $50,000 to $250,000
Dollar Amounts $250,000 to $1,000,000
Dollar Amounts $1,000,000 and Greater

Any help would be greatly Appreciated

MJK

 

[Aladin Akyurek]

I think you need to provide a bit more info, preferably by way of an example.

 

[MJK]

=IF(I2<=50000,"Less than $50,000",IF(I2<=250000,"$50,000 to $250,000",IF(I2<=1000000,"$250,000 to $1,000,000",IF(I2>1000000,"Greater than $1,000,000"))))

 

[Aladin Akyurek]

=IF(I2<=50000,"Less than $50,000",IF(I2<=250000,"$50,000 to $250,000",IF(I2<=1000000,"$250,000 to $1,000,000",IF(I2>1000000,"Greater than $1,000,000"))))

Since you have a lookup task, invoke a lookup formula instead of an IF-formula:

Book5
	A	B	C	D	E	F	G	H	I
1	Table
2	0	Less Than $50,000						Less Than $50,000	23,000
3	50,000	$50,000 to $250,000						Less Than $50,000	50,000
4	250,000	$250,000 to $1,000,000						$50,000 to $250,000	250,000
5	1,000,000	$1,000,000 and Greater						$1,000,000 and Greater	1,200,000
6
7
Sheet1

H2:

=LOOKUP(I2-(LOOKUP(I2,$A$2:$A$5)=I2),$A$2:$B$5)

If you name A2:A5 AMOUNT and B2:B5 DESCRIPTION...

=LOOKUP(I2-(LOOKUP(I2,AMOUNT)=I2),AMOUNT,DESCRIPTION)

If you don't want to keep an external table...

=LOOKUP(I2-(LOOKUP(I2,{0;50000;250000;1000000})=I2),{0,"Less Than $50,000";50000,"$50,000 to $250,000";250000,"$250,000 to $1,000,000";1000000,"$1,000,000 and Greater"})