Calculating discount to achieve a desired GP%

[Rich7048]

First time asking a question so hopefully this makes sense.
We have a business that we want to have 2 categories for customers A and B. We want customer A category to have a GP% of 40% and customer B of 45%.
There are 80 vendors we deal with that have various discounts off of the retail list price.
Is there a formula that I can use to easily figure out the discount to the customer to maintain that 40% GP% using either the discount or mark-up per vendor?
TIA

 

[Sergius]

Hello! If correctly understood. How about this?

Book1
	A	B	C	D	E	F	G	H
1	Produkt	Sales	Klient1	Klient2			40%	50%
2	A	50,00	30	25
3	B	24,00	14,4	12
4	C	65,00	39	32,5
Sheet1

Cell Formulas
Range	Formula
C2:C4	C2	=$B2-($B2*$G$1)
D2:D4	D2	=$B2-($B2*$H$1)

 

[Rich7048]

Thank you that worked great!!!