View Single Post
  #1   Report Post  
goodpasture
 
Posts: n/a
Default odd formula help


I have cell A1 that is a derived number. I have cell B1 that is
dependent on some other calculations (including Cell C1).

My problem is that I want to take cell C1 and have it look at A1 and B1
and adjust to where it makes Cell B1 as close as possible to Cell A1 to
the hundredths or thousands precision.

I'm pretty sure this is going to take some sort of fancy statistical
function that goes a bit beyond my expertise with excel.

Thanks in advance!


--
goodpasture
------------------------------------------------------------------------
goodpasture's Profile: http://www.excelforum.com/member.php...o&userid=23898
View this thread: http://www.excelforum.com/showthread...hreadid=393862