Measurement Of Logarithmic Distance

[Soubasa]

Hello
I need to measure distance in logarithmic
please look at the attach file
I need formula for C1
A1 = 100 & B1 = 150 ... in aritmethic 150-100= 50
in logarithmic I need measure percentage for distance
please consider above question is Bullish
then I need also Bearish situation :
A1 = 150 & B1 = 100

in fact I need formula for Bullish and Bearish distance in logarithmic

Thank you in advance

Book1
	A	B	C	D
1	100
2	150
3
4
Sheet1

 

[Soubasa]

I sent this post to the excelforum.com through this link:

Percentage of Distance Between Two Numbers

Hello I need formula for calculate percentage distance between two number in logarithmic: A1:200 - A2:300. in aritmethic result is 50%, how about logarithmic? & A1:300 - A2:200 . in arimethic result is 33%, how about logarithmic? I need formula in logarithmic Thank you very much

www.excelforum.com