Check if value is in increasingly bigger ranges loop

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!