You can construct a two column table with the lower bounds of your
ranges in one column and the corresponding dollar amounts in another
and use a LOOKUP formula, e.g. in F2

=LOOKUP(E2,Y1:Z5)

where Y1:Z5 contains your table, or alternatively include the values in
your formula like this

=LOOKUP(E2,{0,0.01,0.03,0.05,0.07;0,200,500,750,10 00})


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=523979