# IF Statement

#### _Ken_

##### Board Regular
Hi guys,
What is wrong with this IF Statement...
=IF(D4<250000,A116,A117,IF(AND(D4>250000,D4<500000,A117,IF(AND(D4>500000,D4<1000000,A118,"TOO LARGE")))))

I am trying to do this... If D4 is smaller than 250000 then show A116, and if D4 is greater than 250000, but smaller than 500000 then show A117, and if D4 is greater than 500000, but smaller than 1000000, then show A118. But I can't seem to get it to work for me. Can anybody point out my mistake.

Ken

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
You have an extra A117 in the beginning.

remove the a117 that occurs in "a116,a117,if("

=INDEX(A116:A118,MATCH(D4,{0,250000,500000}))

or

=IF(D4>1000000,"TOO LARGE",INDEX(A116:A118,MATCH(D4,{0,250000,500000})))
This message was edited by Aladin Akyurek on 2002-09-27 13:43

Thanx guys,
That works great Aladin, but Chris, I still could not get any joy out of your suggestion.

Ken

On 2002-09-27 14:02, _Ken_ wrote:
Thanx guys,
That works great Aladin, but Chris, I still could not get any joy out of your suggestion.

Ken

Set up with IF we get:

=IF(D4>1000000,"TOO LARGE",IF(D4<250000,A116,IF(AND(D4>=250000,D4<500000),A117,A118))))

Replies
6
Views
102
Replies
5
Views
271
Replies
3
Views
556
Replies
7
Views
460
Replies
19
Views
566

Threads
1,206,971
Messages
6,075,925
Members
446,170
Latest member
zzzz02

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back