ist actuallly use in the following format


=index(LINEST(known y's,known x's),1) x-intercept
=index(LINEST(known y's,known x's),2) y-intercept


--
indiana_jones81
------------------------------------------------------------------------
indiana_jones81's Profile: http://www.excelforum.com/member.php...o&userid=28172
View this thread: http://www.excelforum.com/showthread...hreadid=477014