IF Statement

[_Ken_]

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

 

[ChrisM]

You have an extra A117 in the beginning.

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

 

[Aladin Akyurek]

=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

 

[_Ken_]

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

Ken

 

[Aladin Akyurek]

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))))