| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Logarithmic equation
As basic as this might seem I cannot find the value of -y- in this equation.I need it to determine at which level my department will be in 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 was clear with my problem.Thankyou -- Pedro Monteiro ------------------------------------------------------------------------ Pedro Monteiro's Profile: http://www.excelforum.com/member.php...o&userid=37865 View this thread: http://www.excelforum.com/showthread...hreadid=574119 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Logarithmic equation
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 http://PeltierTech.com/ _______ "Pedro Monteiro" <Pedro.Monteiro.2cxuqr_1156245005.4582@excelforu m-nospam.com wrote in message news:Pedro.Monteiro.2cxuqr_1156245005.4582@excelfo rum-nospam.com... As basic as this might seem I cannot find the value of -y- in this equation.I need it to determine at which level my department will be in 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 was clear with my problem.Thankyou -- Pedro Monteiro ------------------------------------------------------------------------ Pedro Monteiro's Profile: http://www.excelforum.com/member.php...o&userid=37865 View this thread: http://www.excelforum.com/showthread...hreadid=574119 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 : Equation editor | Excel Discussion (Misc queries) | |||
| Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
| Need Help with #N/A in equation | Excel Discussion (Misc queries) | |||
| Logarithmic Trendline Equation | Charts and Charting in Excel | |||
Linear Mode
