Thanks, that seems to work for some of the cells, but I get a lot of Y
values of "N/A".
To clarify, I want to enter X values that are not already entered, and
have Excel calculate a Y (or a reasonable guess thereof).
So for example, if my X values are 2,4,6,8, and 10; and my
correcponding Y's are 10,20,30,40, and 50 respectivly, I want to be
able to input something like "X=3" and get out "Y=15".
I really wish I knew enough about this stuff to make sence trying to
explain my problem.
I asked my son, he got me as far as a scatter graph, and a Trendline.
So I got this really hard looking formula...
y = 2E-16x4 + 2E-11x3 + 8E-06x2 + 0.6827x + 731.29
Can I just make Excel work that out somehow?
Thanks!
-Tatsu
--
Tatsukun
------------------------------------------------------------------------
Tatsukun's Profile:
http://www.excelforum.com/member.php...o&userid=23820
View this thread:
http://www.excelforum.com/showthread...hreadid=374752