loop back to 00 when 100 is reached

  • Resolved cambob

    (@cambob)


    1 month, 1 week ago

    I have created a form where a user enters some statistics and the calculations outputs a range of 100 numbers in sequence. The range of numbers start at a different number each time. eg, if the first number is 78, the last number is 177.

    I was wondering if there is a way to loop the numbers back to 00 when 100 is reached
    eg. 100 would become 00, eg. 143 would become 43

    exampleis in the link. If you enter a high first number (jersey number) then enter the other fields with numbers you will see the numbers go into 3 digits.

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author CodePeople2

    (@codepeople2)

    Hello @cambob

    I’m sorry, I don’t understand your explanation. However, if you have a number X, and you want to subtract 100 to it if the number is greater than 100, you can use the formula:

    X - (100<=X ? 100 : 0)

    Or if you prefer using the IF operation instead of the ternary operator:

    X - IF(100<=X, 100, 0)

    Now, you need only to replace X by the corresponding number of field’s name.

    Best regards.

    Thread Starter cambob

    (@cambob)

    The IF operation is exactly what I was looking for!
    This will come in handy with other things as well.
    Thanks for figuring out my over explanation ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.