Calculating price/discount increase

[mreinsmith]

As the price increases for an item the discount increases, the data I have is like this:

At $21.49 the discount is 8%
At $89.70 the discount is 17%
At $135.00 the discount is 21%
And so on

I need to figure out how this increase progresses or where the changes occur

I might just be missing an obvious approach but I'm not sure

Any help would be appreciated

Thank you

 

[kevin9999]

Book1
	A	B	C	D
1	Amount	Discount %	Discount $	New Price
2	$89.50	8%	$7.16	$82.34
Sheet1

Cell Formulas
Range	Formula
B2	B2	=IFERROR(LOOKUP(A2,{21.49,89.7,135},{0.08,0.17,0.21}),"No Discount")
C2	C2	=IFERROR(A2*B2,"")
D2	D2	=IF(C2<>"",A2-C2,A2)

 

[mreinsmith]

Thank you

Gave it a shot and it works well

Hopefully as I add more data I will be able to better predict the discount ranges

 

[kevin9999]

You're welcome, and thanks for the feedback.