Can anyone translate this formula??

[mpalermino76]

Does anyone know what this is trying to determine?

=ROUND(IF(W15=0,0,IF(X15=1,LOG(W15)/LOG(X15+0.5),LOG(W15)/LOG(X15))),2)

 

[mikerickson]

It looks like its trying to determine the logarithm of W15 with X15 as a base, with some odd error handling.

If W15 = 0, it avoids the "0 has not logarithm" error by returning 0
If X15 = 1, it avoids the "no number has a logarithm base 1" error by returning Log(W15)base(1.5)

 

[mpalermino76]

Can you explain the logarithm portion of it?

Thanks, by the way, for the quick response

 

[mikerickson]

The worksheet function LOG(X) returns the base 10 logarithm of X.
(the Worksheet function LN(X) returns the natural logarithm as does the VBA function Log(x))

To get the logarithm of a number base B, divide LOG(X) by LOG(B)


So if b^a = x then LOG(x)/LOG(b) = LN(x)/LN(b) = a