What I want to do is to setup a formula to make any number into a number
between chosen X & Y,
For example: turn any number into a 'random but predictable' number between 20 an 30.
So for example, if I want to turn number 1 using the 'formula' it would give 1.
And if I do 2, it will give 2, and so on till it reaches the max.
When I have the number 10, it begins again with 20, and so on.
Can anyone help me out, please?
I'll assume that we are dealing with integers (whole numbers).
Given a number :
. . (1) Divide by 10 * and note the remainder.
. . (2) Add 20 to the remainder.