i want to add numbers to given set of numbers to get a fix value

[neteater]

hi,i am making a credit card debt payback calculator, and wanted to acheive below

suppose outtanding is 100000, i am calculating 5% of it and putting in next cell that is 5000 (this part is done :p )
now what i want to do, add a formula which will add additional value and make the cell value to 10000(this is what i want help for)

then will use simple subtraction formula and remove resulting amount from actual amount, it will come 90000(this can be done)
then again calculate 5% of 90000(that can be done)
and again use formula to percentage amount to make 10000(help needed)
and cycle continues....

regards
Sam

[JeteMc]

Hello Sam and Welcome to Excel Forum.
It might help if you could upload a sample spreadsheet that demonstrates what you are trying to accomplish. I suggest that you start with a smaller "outstanding" value to make calculations easier. Since you already have formulas for certain cells, keep those then manually place the expected values in the cells where you have indicated that help is needed in producing a formula (and unless it is very obvious how you got the expected value, include a detailed explanation).
To upload a sample spreadsheet click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

[Logit]

.
If I correctly understand your request :

	A	B	C	D	E	F	G	H
1	Balance	5%	Result		Formulas
2	100000	5000	95000			B2: =A2*0.05	C2: =A2-B2
3	95000.00	4750.00	90250.00		A3: =C2	B3: =A3*0.05	C3: =A3-B3
4	90250.00	4512.50	85737.50
5	85737.50	4286.88	81450.63		Highlight A3 : C3, then drag down as far as required.
6	81450.63	4072.53	77378.09
7	77378.09	3868.90	73509.19
8	73509.19	3675.46	69833.73

[neteater]

hi, have attached my sheet, right now i am enetering that 10000 value by manual entry.

[JeteMc]

If I understand correctly type 10000 into cell E1 then paste the following into cell B2 of the Scenario A sheet and drag down:

Please Login or Register  to view this content.

Note that I am guess at the rational of having the value manually placed in B71 as 6900.
Let us know if you have any questions.

[neteater]

A million thanks to you, here is the simplified payback calculator for credit card debt settlement, just fill in gree cells and you know when you can relax.

[JeteMc]

Nice, although if I had credit card debt of 100,000 I doubt I would relax until I was returned to dust. LOL
If I may make a couple of suggestions.
1. Modify the formula in B2 and down to read: =IF(ISEVEN(ROW()),"",IF(A1>E$1,E$1,SUM(A1:A2)))
2. Paste the following into cell C2 and copy down: =IF(ISEVEN(ROW()),"",MAX(0,B2-A2))
If you are satisfied that the issue is resolved, please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post.
I hope that you have a blessed day.