I can see log in the Help

I can see arc for sine, tan, etc.

But I can’t see any help for other inverse functions.

I want to find the inverse log of -6: the answer should be ~0.5

I can see log in the Help

I can see arc for sine, tan, etc.

But I can’t see any help for other inverse functions.

I want to find the inverse log of -6: the answer should be ~0.5

What base to the logarithmic fiunction is thought to be implied with your notation “log”?

Assuming base 10 the “inverse logarithm” of -6 should be 0.000001 .

Assuming the natural logarithm we get the result of applying the inverse function to -6 as 0.00248 (rounded!).

Assuming you meant the dyadic logarithm (base 2) the result was 0.016 (rounded).

In case of a cyclometric function the name should be derived from the name of the corresponding trigonometric function by prefixing an “arc” in the tradition of mathematics. Regrettably programming tradition has reduced the prefix to “A” (as also used with hyperbolic functions, then abbreviating “area” instead of “arcus”).

In the case of * lg* or

In Calc the functions are LOG10() and LN() respectively The LOG() function allows for a second parameter to give the base and defaulting to 10 if omitted.

The inverse function with respect to * ln* ( LN() in Calc) is the natural exponential function

Corresponding to LOG(

`Base ^ Exponent`

or `POWER(Base; Exponent)`

.There also is the equivalence `POWER(Base; Exponent) = EXP(Exponent * LN(Base) )`

unfortunately I only see exp.

That is the exponent for the base e (e=2.7182818…ish)

I need (answer) = 10^X where X is the dB/20 for an attenuator.

i.e. for a -6dB attenuator, the exponent will be -6/20 = -0.3

10^(-0.3) = ?

My calculator tells me 0.5012, which is correct

What do you miss in my answer specifically? I still think it ws rather complete.

There is not a specific function name for an exponential function to the base (10 ^(1/20)).

Simply use `=10^(-6/20)`

or (somehow inefficient) `=POWER(10^(1/20); -6)`

If you have to get results for many exponents (your attenuator values) yo surely will make available the `10^(1/20)`

in advance in a dedicated cell…

I do not feel well about the usage of the divisor 20 and the negative sign.

I would expect a ratio of about 0.5 for an attenuation measure of 3dB, or a gain of -3dB.

Looks like you are telling me that I should use Power() function and not exp.

I’ll try that.

6db is double or half voltage

3db is double or half power.

I see Power(,) function

it says a^b. That should do it.

Power(10,x) works, for 6dB it returns 1.995

Thanks.

OT

“6db power ratio (approximately 4 times the power / 1 fourth of the power) corresponding to a voltage ratio of double or half voltage depending on whether used for Gain / Attenuation, Common standard is to put attenuators on a dB scale by power ratio. I wanted to get the voltage ratio back without using a logarithmic scale.”?

Did I get it right?