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

Say C4 is your monthly amount

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

--
Greetings from New Zealand
"Deborah" wrote in message
...
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

Thank you - that's got it. :)

"Bill Kuunders" wrote:

Say C4 is your monthly amount

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

--
Greetings from New Zealand
"Deborah" wrote in message
...
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