Sep 10 2023 08:52 AM
need formula cell 1 payment example 100 cell 2 total own example 1000 need formula (cell 2-cell 1 divide by 20% over 12 months create new balance every month
Sep 10 2023 11:12 AM
need formula (cell 2-cell 1 divide by 20% over 12 months create new balance every month
You might get a response if what you wrote was clear.
I say all this not to be difficult, but to point out that Excel is VERY precise with its math, so it helps to be very precise with the words you use to describe what you want. Your words are open to multiple meanings, and they need to be more clear. The formula(s) you're seeking are no doubt quite basic, but it's hard to help until the need is made more clear.
Maybe you could create a spreadsheet and show us, without formulas, what you are expecting it to look like. Or write it out on paper, the 12 months of entries; let us come up with the formulas that achieve what you depict.