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.