I am trying to create a formula where by the user will input a start figure, an end figure and an instalment figure. then excel will show each instalment and amount reducing the start figure to the end figure. Example:1 start: 600 end : 0 installment:400 Excel should show : 1: 200 (reduced by 400) 2: 0 (reduced by 200 giving end figure) Example:2 start: 1000 end : 200 installment:300 Excel should show : 1: 700 2: 400 3: 200 (end)
Solved by Z. D. in 15 mins