Multiple If Statements (Between)

[reneev]

I'm trying to make a formula that basically says if this number (4.57) is between B and C, then pull in A. Since there is more than 7 options, a regular IFTHAN statement won't work. I just can't think anymore and need help.

[TABLE="width: 178"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]0 - 6 mo[/TD]
[TD]0[/TD]
[TD]0.5[/TD]
[/TR]
[TR]
[TD]6+ mo - 1 yr.[/TD]
[TD]0.6[/TD]
[TD]0.99[/TD]
[/TR]
[TR]
[TD]1 - 2 years[/TD]
[TD]1[/TD]
[TD]1.99[/TD]
[/TR]
[TR]
[TD]2 - 3 years[/TD]
[TD]2[/TD]
[TD]2.99[/TD]
[/TR]
[TR]
[TD]3 - 4 years[/TD]
[TD]3[/TD]
[TD]3.99[/TD]
[/TR]
[TR]
[TD]4 - 5 years[/TD]
[TD]4[/TD]
[TD]4.99[/TD]
[/TR]
[TR]
[TD]5 - 10 years [/TD]
[TD]5[/TD]
[TD]9.99[/TD]
[/TR]
[TR]
[TD]10 - 15 years [/TD]
[TD]10[/TD]
[TD]14.99[/TD]
[/TR]
[TR]
[TD]15 - 20 years[/TD]
[TD]15[/TD]
[TD]19.99[/TD]
[/TR]
[TR]
[TD]20+ years[/TD]
[TD]20[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]

 

[BAlGaInTl]

How about

That's essentially what I did, but I left the OP original table in the order it was in.

I'm going to have to figure out how to do the cool visuals.

 

[Fluff]

There are some add-ins available here https://www.mrexcel.com/forum/about-board/508133-attachments.html
That let you do that.
And there is a test board where you can try them out.