Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Code: -------------------- $31,845 *$16,304* $69,293 $69,858 $227,327 $229,454 $97,252 $94,231 $57,298 $57,097 2.338 *2.435 * *16103* 14287 -------------------- When you change the 2.435 value above, it changes the value of the 16103 cell. I want to change the value in the 2.435 cell until the value in the 16103 cell is closest to the 16304 cell value. This may or may not require macros but can anyone please tack a wack at it and see if you can find a solution. Thanks! -- goodpasture ------------------------------------------------------------------------ goodpasture's Profile: http://www.excelforum.com/member.php...o&userid=23898 View this thread: http://www.excelforum.com/showthread...hreadid=393906 |
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) |