Hi - I am trying to find the value of a tiered range of numbers that are in a
VLookup table. There are three ranges in the lookup table with a percentage
value as the return value (COL 2). I have a number, say 2025 and my lookup
table is the following:
1 5%
1000 6%
2000 7%

From the return value, I need to find the total value of ((999*5%*E5) +
(1000*6%*E5) + (25*7%*E5)) using a formula that knows what to do for any
value above or below 2025 (for example). E5 is a static value. I know
there's got to be something already built into Excel, just can't put my
fingers on it. Your help is greatly appreciated!

Thanks in advance,
-pb100