Logarithmic equation

Pedro Monteiro · Aug 22, 2006

As basic as this might seem I cannot find the value of -y- in thi
equation.I need it to determine at which level my department will be i
terms of sales on day 21.Hence, -x- in the equation representing 21.

_Y=278,85LN(X)+2030,2

Can anyone please help, its my first time in this forum so I hope I wa
clear with my problem.Thankyo

Jon Peltier · Aug 22, 2006

In cell A1 enter 21.
In cell B1 enter this formula:
=278.85*LN(A1)+2030.2
Your answer should be 2879.165

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
774-275-0064
208-485-0691 fax
[email protected]
http://PeltierTech.com/
_______

"Pedro Monteiro"