Calculating percentage values from a min/max table

[Blooze]

So I need to have a calculation value reported based on a set of ranges. For example: if I enter a value of 50, it compares that to 5 sets of ranges, selects the correct range, and applies the corresponding multiplication value (% increase) as well as lists the multiplication value it selected.

[JohnTopley]

Try

in B2

=INDEX($H$3:$H$7,MATCH($A2,$F$3:$F$7,1))

is 1.8 an 80% increase?

[Blooze]

Try

in B2

=INDEX($H$3:$H$7,MATCH($A2,$F$3:$F$7,1))

and format cells as % as 1.8 = 80% increase as you multiplying by 1.8 not 1.8%

I guess I"m dong a lousy job of using descriptors. Basically I'll be entering the "Widget Price" (which is a wholesale price, but I'll be entering 50 or so at a time). Then I need it to calculate the "Total" price, which is determined by multiplying the correct multiplication factor to the corresponding min/max range that the "Widget Price" falls into.
""
So if the "Widget Price" = 50, the "% Increase" column (which I should rename) would show 1.8 (or 80%, I don't care) because that is the factor from the corresponding range and the "Total" would calculate to 90.

[JohnTopley]

Fomula provided does as required.

[Blooze]

So it does. Thank you!