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? 

Hey! I have to imput steps from 1 to 15 and then the time used for that step is displayed in another collumn but then I want this time to stay the same when I change te step number. How do i make a collumn stay the same so I can imput other data?
Thanks!

If i have a list like this
BananaBananaBananaOrangeOrangeCherryCherryBananaOrange
How do i make it keep increment the sequence number in function of the name, i want it to recognized that he already seen this word/Number before in the column. do i have to always put a sorting filter to make it work?
thanks,
Evelyne

i need to increment number using the duplicate criteria, means if the criteria changes the Main Serial Number and Sub Serial Number should change, for example
1.1 604
1.2 604
2.1 605
2.2 605
2.3 605
3.1 606
3.2 606
4.1 607
4.2 607

hope you got my point. kindly help

is there a way to do this but I want to separate the different numbers, for example like
A1 1
A2 1
A3 2
A4 3
A5 3

I would like to automatically calulate the maximum number 1 in a row, maximum number 2 etc