Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Help Please
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 |
#2
|
|||
|
|||
You really need to give us the Formulas you are using, as well as the expected results. How is 2.435 related to 16103 and 16304? More info, please. -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=393906 |
#3
|
|||
|
|||
It really doesn't matter, I just want this cell to increment and while incrementing, it checks the value of another cell until it is not less than another cell. While B1 A1 C1 = C1 + .001 END Please Help!!! -- goodpasture ------------------------------------------------------------------------ goodpasture's Profile: http://www.excelforum.com/member.php...o&userid=23898 View this thread: http://www.excelforum.com/showthread...hreadid=393906 |
#4
|
|||
|
|||
Maybe I'm being dense here, but why don't you just enter 500 instead of 2.435? Maybe enter 13,641? As you said, "it really doesn't matter". I'm thinking, though, that it really -does- matter. I just don't know how they are related. You say changing the 2.435 value changes the 16103 cell. What is the formula in the 16103 cell? Have you checked out ToolsSolver? It may be more along the lines of what you need. Sorry, I can't help further with the info given. Maybe someone else can decipher your example and help you with this. Guess I've been in the 'bad pasture'! Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=393906 |
#5
|
|||
|
|||
How about Tools | Goal Seek... ?
Set the lower cell A1 to increase to the value of B1 by changing C1. This will set A1 & B1 equal. As a macro... Range("A1").GoalSeek Goal:=Range("B1").Value, ChangingCell:=Range("C1") HTH -- Dana DeLouis Win XP & Office 2003 "goodpasture" wrote in message ... It really doesn't matter, I just want this cell to increment and while incrementing, it checks the value of another cell until it is not less than another cell. While B1 A1 C1 = C1 + .001 END Please Help!!! -- goodpasture ------------------------------------------------------------------------ goodpasture's Profile: http://www.excelforum.com/member.php...o&userid=23898 View this thread: http://www.excelforum.com/showthread...hreadid=393906 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |