Hello. I am new to this platform. I use excel for work. I have a question for a formula

[Kairos Slemington]

My question is, what formula or series of formulas would be needed to have a suggested cost of X% to a total cost of $Y, that after X% is added to the total cost, the previously suggested X% does not increase?

 

[awoohaw]

Not really sure of your terminology. Is this what you're asking for?:

IF not some examples would be most helpful.

Book1
	A	B	C	D
1
2
3	Cost %X	Desired Final Price $Y	Item Cost	% Item Cost of Total
4	5.00%	100	95.2380952	5.00%
5	4.00%	100	96.1538462	4.00%
6	3.00%	100	97.0873786	3.00%
7	2.00%	100	98.0392157	2.00%
8	1.00%	100	99.009901	1.00%
Sheet2

Cell Formulas
Range	Formula
C4:C8	C4	=B4/(1+A4)
D4:D8	D4	=(B4-C4)/C4