Results 1 to 2 of 2

Thread: Finding the max value I can add to numbers in a list

  1. #1

    Finding the max value I can add to numbers in a list



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!!

  2. #2
    Hi,

    I solved the Problem the other way round. I just check the entry's that are made and check by subtract them.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •