Searching formula to convert linear data in a range to log values in the same range

Hi all,

I'm searching formula to translate axis values lin to log in a same range, for example I have these linear values in range 1 to 100000

1
20000.8
40000.6
60000.4
80000.2
100000

So they will correpond to this:

1
10
100
1000
10000
100000

But what formula to move from 20000.8 to 10, or 60000.4 to 1000? I know excel will convert automatically lin graphic to log, but I need a formula.

Can you help me please? Thank you in advance.


lin_log.jpg

Could you base something on this?

=LOOKUP(A1,{1,20000.8,40000.6,60000.4,80000.2,100000},{1,10,100,1000,10000,100000})

Thank for reply.

No, 1,10,100,1000,10000,100000 are not supposed to be know, I want to calculate the equivalent from the lin values.