How to get percentile of a given #'s between two other #'s

[d0rian]

Can't figure out how to use PERCENTILE (or any other Excel function) to get a percent figure that represents just where between two defined #'s a 3rd # falls.

For example, if:
A1 = 5.2
A2 = 5.9

And I want Excel to tell me what where, in percentile terms, the number 5.3 falls between 5.2 and 5.9.

What formula do I put into A3 to generate that?

 

[oldbrewer]

for clarity do you expect .166 or .14 ie are 5.2 and 5.9 in or out ?

 

[d0rian]

0.14

 

[r1998]

Hello d0rian
a1 = 5.2
a2 = 5.9
a3 = 5.3
then in a4 use this formula

=(A3-A1)/(A2-A1) %