Hi,
Not sure if this is he best place to ask this but would love your help on this formula. I deposit an amount say $300 in my bank and get interest say $1.5 per day on the given amount. Once the accumulated interest reaches $100 (in a certain no. of days) I reinvest it and deposit it back into the bank which then increases my interest to $2.5 per day and so on. I would like the increasing interest, no. of days taken for each cycle amount accumulated and total amount invested in a table. The part I'm facing difficulty is in the part where the interest increases in each row and also want to constrain it to reinvest it if above $100 only, and also the amount of days it took for me to go above $100 each time.

Io devo fare questo:
In una casella ho un numero che va da 0 a 100 e vorrei che in un altra casella che ha valore iniziale 0 aumenti di una unità quando nella prima casella si passa da 0 a 5 e poi ogni 10. Quindi da 5 a 15 e l'sltra casella passa da 10 a 11, da 15 a 20 e l'altra casella passa da 11 a 12 così via.

I have number in a column. I want to count how many times that there is a break in the numbering sequence. So if you have 2,3,4, 10, 13,14,15. You would get a count of 3 times there was a break between the sequence in the numbers. I have spent two days trying all different kinds of formulas. Please help.

How to make this arrayformula?