Two useful math functions:
The common logarithm function. The natural logarithm of x divided by the natural logarithm of 10.
Logarithms huh?... and the dB function to calculate the logrithmic ratio between two powers (which requires the common log function).
Both return Floats as the result
Syntax:
=LOG10(expression)
=dB(Power1,Power2)
Examples:
x=LOG10(2.88)
=dB(1,0.001)
Code:
'natural log of x divided by the natural of of 10 (common Log)
Function Log10(x As Float) As Float
Log10=Log(x)/2.302585093
End Function
'calculate ratio between two powers as deciBels, P1 & P2 are in Watts. For dBm, specify P2=0.001
Function dB(P1 As Float,P2 As Float) As Float
dB=10*Log10(P1/P2)
End Function