Linest ARRRGHHHH

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can't seem to master this, here goes:
I got years listed in 1 row as follows:
2005 2006 2007 2008 2009
0% X X X 10%
If my goal is a 10% market share by 2009, how the heck do I write a formula
that will return the middle values for years 2006-2008 given a beggining
(O.001%) and a goal (10% by year 2009)?
Furthermore I can't seem master my "Array" since my "Y" values are
discontinuos....ARRGH (exact formula appreciated)
Ken
 
I can't seem to master this, here goes:
I got years listed in 1 row as follows:
2005 2006 2007 2008 2009
0% X X X 10%
If my goal is a 10% market share by 2009, how the heck do I write a formula
that will return the middle values for years 2006-2008 given a beggining
(O.001%) and a goal (10% by year 2009)?
Furthermore I can't seem master my "Array" since my "Y" values are
discontinuos....ARRGH (exact formula appreciated)
Ken
Click to expand...

Ken, are you trying to do this in Microsoft Access (in which case it's
going to require some serious VBA coding) or - probably more
appropriately - in Excel? If the latter, I'd suggest posting your
question in an Excel newsgroup.
 
Back
Top