LinkBack URL
About LinkBacks
Hello
I am making macro that calculates a formula.
Formula suppose to be like that.
50 * Log(((1+(1/n)*Sum)^-0.5)*100
Please, help me to find mistakes.
==================================================
Thank you everyone who contributed!
Please, help me with the code for Similarity Factor Calc. My code gives wrong number.
Hello
I am making macro that calculates a formula.
Formula suppose to be like that.
50 * Log(((1+(1/n)*Sum)^-0.5)*100
Please, help me to find mistakes.
==================================================
Thank you everyone who contributed!
Last edited by Invictus1; 11-22-2015 at 10:11 PM.
Hi, you can use the following code for the format:
Please Login or Register to view this content.
excelbat.com: free Excel tools, macros...
Thank you! Now I get whole number. I put 0 instead of 0.00
On Sheet 1 G17, the worksheet formula multiplies by 100 before 50*Log
=50*LOG(((1+(1/$F$3)*G15)^-0.5)*100)
Please Login or Register to view this content.
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.
Thank you very much, everybody!
Everything works.
Thank you again.
Last edited by JBeaucaire; 11-23-2015 at 01:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks