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

[AIMStudent]

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

[Vitaali]

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