help!
 

I'm trying to figure out a formula that would automatically change the values
in the 3 different cells when 1 month has been reached.

for example:

A1=$2100.00
B1= $25.00
C1= 36 (months remaining)
C1= Date

so $25.00 is a monthly payment so once the date reaches one month I want
$2100.00 to deduct 25.00 and the months remaining to deduct 1 month. and i
want this to be something that is automatic so each time a month is reached
the amount in A1 will go down until it reaches 0.

help!
 

Do you mean D1=date? Assuming the first payment is exactly 1 month from the
date in D1, you could try this formula in A1

=MAX(0,2100-B1*DATEDIF(D1,TODAY(),"m"))

and C1

=MAX(0,36-DATEDIF(D1,TODAY(),"m"))

"butters" wrote:

I'm trying to figure out a formula that would automatically change the values
in the 3 different cells when 1 month has been reached.

for example:

A1=$2100.00
B1= $25.00
C1= 36 (months remaining)
C1= Date

so $25.00 is a monthly payment so once the date reaches one month I want
$2100.00 to deduct 25.00 and the months remaining to deduct 1 month. and i
want this to be something that is automatic so each time a month is reached
the amount in A1 will go down until it reaches 0.

help!
 

Thanks! but what if I want to do it manually? would i have to insert a new
cell F1=Paid? and what if each month I have to change the paid date and I
want A1, B1, and C1 to automatically deduct but in the right sense? do you
know a formula for that?

"daddylonglegs" wrote:

Do you mean D1=date? Assuming the first payment is exactly 1 month from the
date in D1, you could try this formula in A1

=MAX(0,2100-B1*DATEDIF(D1,TODAY(),"m"))

and C1

=MAX(0,36-DATEDIF(D1,TODAY(),"m"))

"butters" wrote:

I'm trying to figure out a formula that would automatically change the values
in the 3 different cells when 1 month has been reached.

for example:

A1=$2100.00
B1= $25.00
C1= 36 (months remaining)
C1= Date

so $25.00 is a monthly payment so once the date reaches one month I want
$2100.00 to deduct 25.00 and the months remaining to deduct 1 month. and i
want this to be something that is automatic so each time a month is reached
the amount in A1 will go down until it reaches 0.

help!
 

thank you so much! i wouldn't have figured that out on my own!!

"daddylonglegs" wrote:

Do you mean D1=date? Assuming the first payment is exactly 1 month from the
date in D1, you could try this formula in A1

=MAX(0,2100-B1*DATEDIF(D1,TODAY(),"m"))

and C1

=MAX(0,36-DATEDIF(D1,TODAY(),"m"))

"butters" wrote:

I'm trying to figure out a formula that would automatically change the values
in the 3 different cells when 1 month has been reached.

for example:

A1=$2100.00
B1= $25.00
C1= 36 (months remaining)
C1= Date

so $25.00 is a monthly payment so once the date reaches one month I want
$2100.00 to deduct 25.00 and the months remaining to deduct 1 month. and i
want this to be something that is automatic so each time a month is reached
the amount in A1 will go down until it reaches 0.