orangecasa
New Member
- Joined
- Jan 23, 2018
- Messages
- 2
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
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"