Need Excel to return 1 of 6 answers? If/Than/and

[kurtma]

Hello! I keep getting stuck on this one. Any help would be greatly appreciated.

I am inputting a number into H3, then want excel to give the answer in I3.

If H3 is less than 1,499,999 I want it to return 0
If H3 is between 1,500,000 and 2,000,000 I want it to return 1000
if H3 is between 2,000,001 and 3,000,000 i want it to return 1500
if H3 is between 3,000,001 and 4,000,000 i want it to return 2500
if H3 is between 4,000,001 and 5,000,000 i want it to return 5000
if H3 is greater than 5,000,001 I want it to return 10,000

I have it set up where A9 is 0, b9 is 1,499,999, and c9 is 0
a10 is 1,500,000, b10 is 2,000,000 and c10 is 1000, and so on

How do I get that many nested if functions?
Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
How about
=INDEX(C9:C14,MATCH(H3,A9:A14,1))

 

[gaz_chops]

Welcome to the forum, create a simple table as below, then use

=LOOKUP(H3,$D$3:$E$8)

My table is in D3:E8

 

[kurtma]

Hi & welcome to MrExcel.
How about
=INDEX(C9:C14,MATCH(H3,A9:A14,1))

Holy Moly, you are a rockstar, thanks!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[kurtma]

Welcome to the forum, create a simple table as below, then use

=LOOKUP(H3,$D$3:$E$8)

My table is in D3:E8
View attachment 17197

Thanks so much for your reply and help!