if or functions

  • Thread starter Thread starter michelledean via OfficeKB.com
  • Start date Start date
M

michelledean via OfficeKB.com

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
 
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}
 
Back
Top