Re: Combining Multiple IF AND and OR statements

It is all about how you set your refererence table up.

[TABLE="width: 154"]

Data

Return

- 50,000

[TD="align: right"]8

[/TD]

50,000

[TD="align: right"]13

[/TD]

100,000

[TD="align: right"]20

[/TD]

500,000

[TD="align: right"]40

[/TD]

1,000,000

[TD="align: right"]100

[/TD]

[/TABLE]

If you set the table like the above then put your value in D2 the following.

=VLOOKUP(D2,A2:B6,2)

This will give you the correct answer.

Take care

Smallman