Completely Stuck

[cellphones218]

$90	$300	$500	$5
$300	$80	$25	$800
$700	$90	$35	$25

<colgroup><col span="4"></colgroup><tbody>
</tbody>

I NEED HELP!

Basically I need to create this

If it's less than 200, subtract 30%, if it's between 200-300 subtract $50, if it's between $300-450 subtract $60, if it's between 450-1000 subtract $75.

This is so confusing. I tried googling everywhere.

 

[cellphones218]

Let A2 house 700.

In B2 enter:

=A2-LOOKUP(A2,{0,200,300,450},{30,50,60,75})

It worked!!!
So basically, if between 0-200 subtract 30, 200-300 subtract 50, 300-450 subtract 60, 450+++ subtract 75

And i can just change numbers if needed? !!
THANK YOU!!!

 

[Aladin Akyurek]

It worked!!!
So basically, if between 0-200 subtract 30, 200-300 subtract 50, 300-450 subtract 60, 450+++ subtract 75

And i can just change numbers if needed? !!

Yes.

THANK YOU!!!

You are welcome and thanks for the update.

 

[inactiveuserps07]

Hi, cellphone. The problem here is that, in your original post you used the wording "if it'sless than ...," and we all thought you meant "it" was dollars, when you really meant quantity. In other words, you're trying to apply a discount when QUANTITY goes up, where we thought you were trying to apply the discount as PRICE went up. I altered your formulas in your spreadsheet; see if those are now the numbers you were expecting.