if or functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

michelledean - 19 Mar 2006 01:53 GMT

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

Reply to this Message

daddylonglegs - 19 Mar 2006 02:11 GMT

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

=LOOKUP(E2,Y1:Z5)

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

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

Reply to this Message