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.

 

[dreid1011]

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.

What is the logic behind converting the numbers? Is it 99 equal groups of numbers in order from 1 to 6561?

 

[dreid1011]

Perhaps this to get you started. Otherwise, there might be a much simpler equation that can be applied to get the same results.

=LOOKUP(A2,{1,67,133,199,266,332,398,464,531,597,663,730,796,862,928,995,1061,1127,1193,1260,1326,1392,1459,1525,1591,1657,1724,1790,1856,1922,1989,2055,2121,2188,2254,2320,2386,2453,2519,2585,2651,2718,2784,2850,2917,2983,3049,3115,3182,3248,3314,3380,3447,3513,3579,3646,3712,3778,3844,3911,3977,4043,4109,4176,4242,4308,4375,4441,4507,4573,4640,4706,4772,4838,4905,4971,5037,5104,5170,5236,5302,5369,5435,5501,5567,5634,5700,5766,5833,5899,5965,6031,6098,6164,6230,6296,6363,6429,6495},{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99})

Or this if you keep the lists in a sheet:

=LOOKUP(A2,B1:B99,C1:C99)

 

[serge]

After endless of formulas calculations, I end up with 2 separate numbers of 4 digits each, I'm also using the help of a software that can only use a 4 digits number to achieve it's calculations, so I'm trying to reduce those 2 numbers of 4 digits into 1 number of 4 digits for the software to work.

 

[dreid1011]

You could try this for a much simpler alternative, however, it only works one way, converting 1-6561 to 2 digits. I don't see how you could go back the other way unless you worked with the decimal values. Also, this might be off by 1. IE: 133 shows in range for 02, when I believe it should be 03, but that all depends on the logic behind this if I have gotten it wrong.

=TEXT(ROUNDUP(A1*0.015,0),"00")

 

[dreid1011]

After endless of formulas calculations, I end up with 2 separate numbers of 4 digits each, I'm also using the help of a software that can only use a 4 digits number to achieve it's calculations, so I'm trying to reduce those 2 numbers of 4 digits into 1 number of 4 digits for the software to work.

That doesn't really explain how any number from 1-6561 should be converted to 1-99 if my original guess was wrong.

 

[Phuoc]

6561 = 81*81.

You need 81 different characters to convert it.

The BASE function only has 36 characters, so it only converts numbers less than or equal to 1296 to a 2-character result.
.

 

[serge]

That doesn't really explain how any number from 1-6561 should be converted to 1-99 if my original guess was wrong.

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.

 

[serge]

Also maybe creating a Tab that will have every single 4 digits numbers ( 1 to 6561 ) with their own reference 2 digits decimal numbers and using a Lookup formula to return the 2 digits number and a different formula to return the 4 digits number ? I don't know I just speculate.I'm not an expert like you guys.

 

[dreid1011]

Also maybe creating a Tab that will have every single 4 digits numbers ( 1 to 6561 ) with their own reference 2 digits decimal numbers and using a Lookup formula to return the 2 digits number and a different formula to return the 4 digits number ? I don't know I just speculate.I'm not an expert like you guys.

I am by far not an expert here. I am still learning as I try to help others. The first method I suggested uses a lookup, but it still only goes one way. You could reverse the lookup column with the result column but it would not give you the exact number back. The second method also only goes one way because it involves rounding the result which eliminates the decimals. If the unrounded results could get it to where it needs to be, then you could use another formula to reverse the results, but as it is, I am not sure how to achieve that. Hopefully someone else can weigh in while I tinker and try and figure it out.