Check if value is in increasingly bigger ranges loop

[zanchin]

Good evening

To be completely fair I don't know which title to put, so I hope I can explain myself better even though english is not my primary language.
Basically I have got a starting value and I need an UDF to check if this value is in a determined range and, if it is, add a certain value and recheck it after the value is added.. This goes on until the value I have isn't included in any range.

I put an example of what I need attached to the thread.

I beg you to help me since I've been trying with formulas for the past month and I couldn't get around to do this and I can't program VBA to save my life.

Thank you so much and Merry Christmas!

[saravnepali]

I really wanted to help but wasn't able to understand the logic.

Is this all number all part of one set of data ??

NOT also clear how you get the values on the Column G, value I need to end up with.

If you show more examples and may be more logic on what you want would help.

Also, try to make cells different colours on what has been given data and what is the expected result

[zanchin]

Hi! Sorry for being unclear, I really don't know how to explain myself better than this
I have the concept clear in my mind because I work on it everyday but it's hard for me to explain it to others since english is not my primary language

I'll upload the same file with more examples

hope you can help!

[Akuini]

1. Can you explain why 5 became 8?
2. What happen if the starting number is 11?