monthly profit

[mattb123]

Hi

I've been stuck for ages and cant seem to figure this problem out in my head even though i think its a fairly simple question!!

My situation is as follows:

i have a debt amount of £20.00
monthly i earn £10.00

i want to show a row that shows the amount of profit in each month if the debt is being paid off

i would expect the answers to look like
month 1 profit 0
month 2 profit 0
month 3 profit 10
month 4 profit 10

can anyone help please !!!

 

[Andrew Poulsom]

Welcome to MrExcel.

Formula in B4 copied down:

Excel 2010
	A	B
1	Debt	20
2	Income	10
3	Profits
4	Month 1	0
5	Month 2	0
6	Month 3	10
7	Month 4	10
Sheet1

Cell Formulas
Range	Formula
B4	=MAX(0,(B$2*ROWS(B$4:B4))-B$1)-SUM(B$3:B3)

 

[mattb123]

Hi

Is it possible to have the income input monthly so this can be a variable?

[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]debt[/TD]
[TD="width: 64, align: right"]20[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]month 1[/TD]
[TD]month 2[/TD]
[TD]month 3[/TD]
[TD]month 4[/TD]
[TD]month 5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]income[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]profit[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

Sure:

Excel 2010
	A	B	C	D	E
1	Debt	20
2		Month 1	Month 2	Month 3	Month 4
3	Income	10	10	10	10
4	Profits	0	0	10	10
Sheet1

Cell Formulas
Range	Formula
B4	=MAX(0,SUM($B3:B3)-$B1)-SUM($A4:A4)

 

[mattb123]

Genius, thanks a lot