Named Ranges with If Statement

[orangecasa]

Hello,
I want to use named ranges in my formula to reduce the size of my if statement. If I type 530,000 into H7 then I want a formula in F8 to reference the "starting range" and "end range" to include the corresponding multiplier range number that will be multiplied by the H7 value. Example is below along with named ranges and table. I know how to do this with a long if statement, but am looking to shorten it.



Named Ranges

"Starting Range"= I:I
"Ending Range" =J:J
"Multiplier"= K:K

​

<tbody>
</tbody>

Column G	Column H	I1(Starting Range)	J (Ending Range)	K (Multiplier Range)
		0	500,000	.1
		500,001	600,000	.12
		600,001	700,000	.14
		700,001	800,000	.16
H7 Value	530,000
H8 Calc.	63,600

<tbody>
</tbody>

Example

If F7 Value=$530,000
Then F8 Value= H7 "530,000"*K2 ".12"

 

[orangecasa]

The example cells should be H7 and H8 instead of F7 and F8

 

[Nishant94]

<b>Unknown</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Column G</td><td style=";">Column H</td><td style=";">I1(Starting Range)</td><td style=";">J (Ending Range)</td><td style=";">K (Multiplier Range)</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">0</td><td style="text-align: right;;">5,00,000</td><td style="text-align: right;;">0.1</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">5,00,001</td><td style="text-align: right;;">6,00,000</td><td style="text-align: right;;">0.12</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">6,00,001</td><td style="text-align: right;;">7,00,000</td><td style="text-align: right;;">0.14</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">7,00,001</td><td style="text-align: right;;">8,00,000</td><td style="text-align: right;;">0.16</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="color: #333333;;">Value</td><td style="text-align: right;;">530000</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">Calc.</td><td style="text-align: right;;">63600</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet3</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">H8</th><td style="text-align:left">=LOOKUP(<font color="#0000FF">H7,$I$2:$I$5,$K$2:$K$5</font>)*H7</td></tr></tbody></table></td></tr></table><br />