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

What if its greater than 700??
--
Gary''s Student - gsnu200905


"rt" wrote:

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"})
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"rt" wrote:

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

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.

"Luke M" wrote:

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"})
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"rt" wrote:

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