AIMStudent, thank you for a fast response. I checked your equations and the first one with linear scale worked perfectly. Thank you.
Unfortunately I found a problem with the second one - Log equation.
Dollar Amount as Log = [Desired % * (LOG($ High Price) - LOG($ Low Price))] + LOG($ Low Price)
I tested it multiple times and it produces the wrong results. For example:
If the high price is $100 and the low price is $1.00, and I input 100%, the result I get is $200. It should be $100, not $200 because my high price is $100 at the 100% top. There is no $200 in my price range between $1 and $100.
Is this normal behavior or did something go wrong here?
By the way, when I did the same test with the first linear equation you provided, I did get the correct $100 answer.
Thanks!
Vitali
