Excel Log Function is Log(Base10)
VBA Log Function is Natural Log
Change this line as shown
New result =K_Array(CR) = Log(Split(FileLines(CR), ",")(F)) / Log(10#)
table_aapl_test.csv 0.50476314127199400
Excel Log Function is Log(Base10)
VBA Log Function is Natural Log
Change this line as shown
New result =K_Array(CR) = Log(Split(FileLines(CR), ",")(F)) / Log(10#)
table_aapl_test.csv 0.50476314127199400
Please take the time to read the Forum FAQ
Posting Permissions
Reply With Quote