Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |