If formula

  • Thread starter Thread starter rt
  • Start date Start date
R

rt

I have a total $ amount in cell G30. I want a formula in G31 that calculates
a shipping cost as follows: Less than $50 = $10; Greater than $50 Less than
$200 = $15; Greater than $200 Less than $700 = $20. Thanks in advance. rt
 
The way your wrote your conditions, your excluding midpoints (what happens if
it equals 50?) Also, what happens if you're over 700? Assuming each cuttoff
point is part of the lower group, formula is:

=LOOKUP(G31,{0,51,201,701},{10,15,20,"Something else"})
 
Alternately, if your list is longer than you specified here, you can make a
table with your lower limits in column A and your shiopping costs in B:

0 10
50 15

etc.

and do =VLOOKUP(G30,A:B,2) to return the cost.

Assumes your table is in columns A and B.
 
Back
Top