surminderbains
New member
- Joined
- Sep 15, 2015
- Messages
- 5
- Reaction score
- 0
- Points
- 0
Hi Excel-Experts,
I'm trying to figure out how I can find out what maximal number I can add to a list without that the amount between two numbers in the list is bigger than 10.
For example:
x1=10
x2=20 => I can add 0 to this number, because the gap between x1 and x2 is already 10, a higher gap is not allowed.
x3=15 => I can add 15 to here and the gap to x2 and x4 would be 10
x4=20 => I can add 0 here, because the gap to the following number is already 10
x5=10 => I can add 20 here, because the gap would be 10 for x4 and x6.
x6=20
Thanks for your help!!
I'm trying to figure out how I can find out what maximal number I can add to a list without that the amount between two numbers in the list is bigger than 10.
For example:
x1=10
x2=20 => I can add 0 to this number, because the gap between x1 and x2 is already 10, a higher gap is not allowed.
x3=15 => I can add 15 to here and the gap to x2 and x4 would be 10
x4=20 => I can add 0 here, because the gap to the following number is already 10
x5=10 => I can add 20 here, because the gap would be 10 for x4 and x6.
x6=20
Thanks for your help!!