InvestorsHub Logo
icon url

AIMStudent

02/14/21 8:56 PM

#45069 RE: AIMStudent #45068

Sorry, error in previous example:

[100% * (LOG(100.00) - LOG(0.00))] + LOG(0.00) = 2.0

is incorrect. Should be:

[100% * (LOG(100.00 - LOG(1.00))] + LOG(1.00) = 2.0

-AIMStudent
icon url

Vitaali

02/14/21 10:35 PM

#45070 RE: AIMStudent #45068

Hi AIMStudent, Excel spreadsheet.
You were right, I did confuse dollar amount and Log value. After applying your fix the equation started to work beautifully. Thank you so much again. You saved me from a lot of frustration. Some day I'd like to understand math as well as you.

One more question. How do I combine these two equations into one:
10^2.0 = $100 and [100% * (LOG(100.00 - LOG(1.00))] + LOG(1.00) = 2.0
so that they take up only one cell in my spreadsheet? Right now I can only do it in two steps, and two cells.

Vitali