I have a sheet that I want to return a dollar amount for a specific range of %
ages.

EX:

Column E Column F
2.5% I have the following Criteria that this needs to follow
if Column E

equals.99 or less earns $1000
2.99 - 1.00 earns 750
4.99 - 3.00 earns 500
6.99 - 5.00 earns 200
7.00 or more earns 0

I need column F to return one of the criteria amounts

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200603/1

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