Yahoo Clever wird am 4. Mai 2021 (Eastern Time, Zeitzone US-Ostküste) eingestellt. Ab dem 20. April 2021 (Eastern Time) ist die Website von Yahoo Clever nur noch im reinen Lesemodus verfügbar. Andere Yahoo Produkte oder Dienste oder Ihr Yahoo Account sind von diesen Änderungen nicht betroffen. Auf dieser Hilfeseite finden Sie weitere Informationen zur Einstellung von Yahoo Clever und dazu, wie Sie Ihre Daten herunterladen.

Kraig fragte in Business & FinanceInvesting · vor 1 Jahrzehnt

How do I figure out progressive savings on excel?

I've figured it out before, but I lost the Excel formula. You deposit $1 the first day, the next day you deposit $1, and each next day, you increase your deposit by $1. This works for any currency. Does anyone know what the excel formula for this might be? If I recall correctly, at deposit 100 which would be a $100 deposit, if you still have the previous deposits, you will have $5050. But I want the excel worksheet for this. Theoretically it'll put you into the millions. Theoretically. Since you won't likely be able to afford to keep it up for a long time, I'd suggest resetting back to $1 when you top out. Each time you must reset, you will lively reset at a higher number. But I need that formula.

And I hope I've opened eyes to a great idea too.

Update:

Not many saw it or cared. I found my original worksheet, but thanks, xosexychikxo.. Aside from the technical issue, have I opened any eyes with the concept?

1 Antwort

Relevanz
  • vor 1 Jahrzehnt
    Beste Antwort

    Sum = 1+2+3+...+(n-1)+n

    Sum = n+(n-1)+...+3+2+1

    Add the two:

    2*Sum = (n+1) +(n+1) .... = n*(n+1)

    Thererfore: Sum = n*(n+1)/2

Haben Sie noch Fragen? Jetzt beantworten lassen.