On Sheet 1 G17, the worksheet formula multiplies by 100 before 50*Log
=50*LOG(((1+(1/$F$3)*G15)^-0.5)*100)
![]()
Equat3 = 50 * WorksheetFunction.Log(Equat2 * 100) Similarity = Application.Round(Equat3, 0)
On Sheet 1 G17, the worksheet formula multiplies by 100 before 50*Log
=50*LOG(((1+(1/$F$3)*G15)^-0.5)*100)
![]()
Equat3 = 50 * WorksheetFunction.Log(Equat2 * 100) Similarity = Application.Round(Equat3, 0)
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks