Hi Vitaali, Excel spreadsheet...
I think you may be confusing dollar amount and Log value.
For the example you provide, the amount returned should be 2.0, not $200.
[100% * (LOG(100.00) - LOG(0.00))] + LOG(0.00) = 2.0.
Hence, in my previous post I referenced it as Dollar Amount as Log value.
To derive the Log value to a "true" dollar amount you will need to convert from the log value using either equation below:
Dollar Amount = 10^Dollar Amount as Log value, or
Dollar Amount = power(10, Dollar Amount as Log value)
Again, using your example:
10^2.0 = $100
Hope that helps.
-AIMStudent
