Tieried Billing.

[adaryana]

Hi.

I am have this data
0 - $499,999 - 1.15%
$500,000 - $999,000 - 0.98%
$1,000,000 - $1,999,999 - 0.93%
$2,000,000 - $2,999,999 - 0.88%
$3,000,000 - $3,999,999 - 0.83%
$4,000,000 - $4,999,999 - 0.78%
$5,000,000 + - 0.73%

If column A... I have different dollar amounts.
how can I get the fees to in column B. (would rather have a non-macro solution). Thanks a lot.
Please help.

 

[Juan Pablo González]

Is this the same as

http://www.mrexcel.com/board2/viewtopic.php?t=46204

same data but different %...

 

[adaryana]

Sorry But this is the acvtual problem.

Also I have abt 650 dats pts in Column A. I need the fees in Column B.
Does anyone have a solution. Thanks!