I need some help for a complex formula

[Lawren Petersen]

Hey there,

So what I am trying to do if figure out how to write a formula for an investment.

If each month I put $2500 in and then when that equals $50,000 it automatically purchases an investment and leaves the left over money until it reaches $50,000 again. At the same time it adds $700 each month to the amount that I am putting in.

Any help would be awesome.

thanks

[#2]

Lawren,

it sounds like you are asking us to do your homework.

Besides it is not clear what the formula is supposed to calculate: amount or time?

[#3]

lol. no its not homework i have been trying to figure this out for my self. with no luck so far. i want to know both the amount and time it will take in months.

[#4]

Lawren,

it's simply adding and subtracting numbers.

See the file.