Originally Posted by

**LadyJane** Hi everyone,

I hope this is in the right forum.

I have a list of numbers and am looking for a formula that will convert these numbers in the following manner:

0.1 -> 0.1

0.2 -> 0.2

0.3 -> 0.4

0.4 -> 0.8

0.5 -> 1.6

0.6 -> 3.2

0.7 -> 6.4

0.8 -> 12.8

0.9 -> 25.6

1.0 -> 51.2

As you can see, numbers in the second column are always double the previous value.

I would like a formula (if one exists) that can be applied to each number in the first column to obtain the number in the second column. I would then use this formula to convert the in-between numbers (0.34, 0.567 etc...) in the same manner. Original number will always be in between 0 and 1 as they represent percentiles.

Thank-you