odd formula help

G

goodpasture

I have cell A1 that is a derived number. I have cell B1 that i
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 B
and adjust to where it makes Cell B1 as close as possible to Cell A1 t
the hundredths or thousands precision.

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

Thanks in advance
 
S

swatsp0p

You may have more success getting a helpful answer if you give mor
details. What do you mean by "derived number"? You also need t
understand that a formula can't change the value in another cell (tha
would require VBA code). Also, a formula can't change precision (o
formatting -- conditional formatting being the exception), an
formatting is required to set the precision that Excel displays.

More info, please

Bruc
 
Top