Multiply the coefficient of ln(x) by ln(10).
Alternatively, get the coefficients in the worksheet by selecting a 5 row by
2 column range and entering the array formula
=LINEST(range-with-y-values,LOG10(range-with-x-values),TRUE,TRUE).
To enter an array formula complete data entry with the CTRL+SHIFT+ENTER
combination rather than just the ENTER or TAB key.
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
