Simple Budget Formula Please

[Deborah]

Sorry, I'm sure I could do this but at this time of night, I thought I'd stop
trying to figure it out and ask! A simple budget calc for a friend:

C1 = the money owed
C3 = the amount paid back so far (this cell equals B34 which is totalling a
column of monthly figures paid back)

So, for example, £2000 is owed, £100 paid back so far, I need a forumula to
display how many months are left before the original figure is paid back
based on it being paid back at £100 a month but allowing higher figures to be
paid in also.

I'm sure it's simple but can't get my head round it right now

Thank you

 

[Bill Kuunders]

Say C4 is your monthly amount

enter in c5 or elsewhere
=(c1-c3)/c4 to get how many months

 

[Deborah]

Thank you - that's got it.

Say C4 is your monthly amount

enter in c5 or elsewhere
=(c1-c3)/c4 to get how many months