View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davesexcel
 
Posts: n/a
Default polynomial equation


0.057672821
y= -0.0881x^2+2.8089x+0.0505.

If the absorbance reading (y) = 0.212, how do I calculate the value of
x?
I am just thinking
A1=B2
B2=-.0881*C1^2+2.8089*C1+.0505
then I went to Tools, Goal seek
set the value of A1 to .212 by changing Cell C1


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519106