Taking column value for the if condition in excel

I'm creating target revision tool to change the old target to new target based on sales percentage. It's difficult to keep all the sale percentage in If formula as conditions. So I added the between value condition (Ex:-1.99%, -1.00%) in Column G and H.

Now the problem is If column C value (Ex: -1.00%) is in btween any of the % range in Column G and H, then the target value in Column B (Ex:10) should be Increased/Decreased based on the value in Column I straight to the range in Column G and H (Ex:-1.90%, -1.00% = 10) and calculated as 20 in Column D (revised target).

I'm attaching the screen shot of the excel.

Calculation column

Condition range