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