Returning a 2 digits number !

[serge]

Hi,

I don't know if it's possible but I'm gone ask anyway.

Would it be possible to create a formula that will reduce which ever number from 1 to 6561 and return a number of 2 digits from 01 to 99 ?
And when I use those 2 digits number in reverse a formula would give me the original number I started with ?
Maybe with a Lookup function ?

Thank you.

 

[BigBeachBananas]

Thank you very much for answering my post.
Every single number from 1 to 6561 must have an equivalent number from 1 to 99 and been able to be reverse to the exact number, maybe like you said using decimal, maybe as and example if the formula can transfer :
65 to 65
165 to 65.1
265 to 65.2
365 to 65.3
......
......
3665 to 65.30
6561 to 65.60

Don't quote me for those number above, it's just to show as an example, do you think it could work this way ?
Using the decimal this way in your formula would return the exact 4 digits number I think ?
The question is how many arguments a formula can handle, that I don't know only you can answer this question.

If decimal is allowed then here's one possible solution.

Scaling factor = (99-1)/(6561-1) = 0.014939

Mapping from 1-6561 -> 1-99:
Y=(X-1)*Scaling factor + 1

Example mapping 165:
Y=(165-1)*0.014939+1 = 3.45

You can go from 3.45 to 165 using basic algebra rearranging the above equation.

 

[serge]

Thank you BigBeachBananas, would the reverse formula would give me back the exact 165 ?

 

[BigBeachBananas]

Thank you BigBeachBananas, would the reverse formula would give me back the exact 165 ?

Yes.

 

[serge]

Thank you guys or your help, Im gone see how I can use it, working with the software, I really appreciate all your help.