what's wrong with custom function?
In VBA, LOG() is the natural log function. In XL, LOG(x) is the log
to base x, with the default being base 10.
If you want log base 10 in VBA, use Log(x)/Log(10)
?Log(3811)/Log(10)
3.58103894877217
In article ,
"Juggernnath" wrote:
LOG(3811)=3.5810389
*3.3093=11.850732
14.811-11.850732=2.9602678
SQR(2.9602678 0) = 1.72
I didn't understand if you made calculating mistake or tried to say
something else...
|