Replies to post #45067 on A.I.M. Users Bulletin Board (AIMUSERS)

[AIMStudent]

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

[Toofuzzy]

Vitaalli

Why bother using log if linier works ?

Sometimes
Toofuzzy