ok im back from my little holiday, thanks for your help

Ok how do I get this sum do I make a table or is there some cleaver
sum?
I get a number that says say 6.90% and the chart shows that’s $200
How can I make a sum that adds/ convents that to get total??
It will start at 6.80% and go up more but never down that wouldn’t be
entered?

6.80% $100
6.90% $200
7.00% $300
7.10% $400
7.20% $500
7.30% $600
And so forth


--
phat al
------------------------------------------------------------------------
phat al's Profile: http://www.excelforum.com/member.php...o&userid=34988
View this thread: http://www.excelforum.com/showthread...hreadid=548169